三张表关联查询(原生sql,任何关系型数据库都可以用)

时间:2022-02-06 05:03:13

三张表:merchant_area,sys_area,merchant.

SELECT a.id AS "id",

a.merchant_name AS "merchantName",
a.merchant_type AS "merchantType",
a.create_time AS "createTime",
a.is_delete AS "isDelete",
c.id AS 'area.id',
c.name AS 'area.name'
FROM merchant a 
LEFT JOIN merchant_area b ON b.`merchant_id` = a.`id` 
LEFT JOIN sys_area c ON c.`id`=b.`area_id`