mysql多表左链接查询

最新推荐文章于 2024-07-30 03:56:39 发布

network_dream

最新推荐文章于 2024-07-30 03:56:39 发布

阅读量504

点赞数

分类专栏： mysql 文章标签：多表查询

本文链接：https://blog.csdn.net/network_dream/article/details/100120391

版权

mysql 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

事例：

SELECT
	a.gifts_num,
	a.current_num,
	a.nick_name,
	a.sku_id,
	a.sku_name,
	a.sku_price,
	a.create_time,
	b.plat_order_id,
	b.nick_name,
	c.sendee_address_info,
	b.thanks_content 
FROM
	share_gifts_info AS a
	LEFT JOIN (
		get_gifts_info AS b
		LEFT JOIN (
			order AS c
			LEFT JOIN ( 
				store_deliver_goods AS d  LEFT JOIN store_waybill AS e 
					ON d.waybill_id = e.id 
				) ON c.plat_order_id = d.plat_order_id 
		) ON b.plat_order_id = c.plat_order_id 
	) ON a.share_gifts_info_id = b.share_gifts_info_id