当前位置：网站首页>mysql多表左链接查询

mysql多表左链接查询

2022-08-09 20:51:00 【全栈程序员站长】

大家好，又见面了，我是你们的朋友全栈君。

事例：

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
  • UNIX_TIMESTAMP(datetime)
  • FROM_UNIXTIME(unixtime)

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/105811.html原文链接：https://javaforall.cn

原网站

版权声明
本文为[全栈程序员站长]所创，转载请带上原文链接，感谢
https://cloud.tencent.com/developer/article/2069180

边栏推荐

猜你喜欢

随机推荐