sql单表转左连接

最新推荐文章于 2022-12-26 17:31:27 发布

chai1230

最新推荐文章于 2022-12-26 17:31:27 发布

阅读量150

点赞数

分类专栏： mySql索引

本文链接：https://blog.csdn.net/chai1230/article/details/116748902

版权

mySql索引专栏收录该内容

2 篇文章 0 订阅

订阅专栏

索引字段

在这里插入图片描述

SELECT
	b.id,
	pack_type AS packType,
	logistics_template AS logisticsTemplate,
	is_print AS isPrint,
	print_user AS printUser,
	DATE_FORMAT(
		create_tm,
		'%Y-%m-%d %H:%i:%s'
	) AS createTm,
	is_check AS isCheck,
	is_cancel AS isCancel,
	print_index AS printIndex,
	boxCode AS boxCode,
	shipmentPort AS shipmentPort,
	IFNULL(uploadState, 0) AS uploadState
FROM
	(
		SELECT
			id
		FROM
			tb_order
		WHERE
			(
				uploadState = '1'
				AND is_cancel = '0'
				AND order_status = '0'
			)
		ORDER BY
			modify_tm DESC
		LIMIT 0,
		100
	) tb_order2
LEFT JOIN tb_order b ON tb_order2.id = b.id