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

最新推荐文章于 2024-07-25 18:23:42 发布

超级巨星a

最新推荐文章于 2024-07-25 18:23:42 发布

阅读量8.4k

点赞数 1

分类专栏： Mysql

本文链接：https://blog.csdn.net/JavaMk/article/details/50879020

版权

Mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

三张表：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`