左连接查询

最新推荐文章于 2025-11-18 09:09:59 发布

原创最新推荐文章于 2025-11-18 09:09:59 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个具体的SQL查询案例，展示了如何从两个表中联接数据并筛选特定分支ID的记录。该查询包括了多个字段的选择，并按创建时间进行了排序。

SELECT
	a.PLAN_NAME        AS planName,
	a.PLAN_ID          AS planId,
	a.DATA             AS DATE,
	a.PLAN_ORG         AS planOrg,
	a.PROFI_CHECK_ID   AS profiCheckId,
	a.BRANCH_ID        AS branchId,
	a.CREATE_TS        AS createTs,
	a.NOTE             AS note ,
	b.PROFI_CHECK_ID   AS profiCheckId,
	b.PROJECT_NAME     AS projectName,
	b.METHOD_NO        AS methodNo,
	b.MACHINE_NAME     AS machineName,
	b.MACHINE_NO       AS machineNo,
	b.WORKER           AS worker,
	b.RESULT           AS RESULT,
	b.RESULT_STATE     AS resultState,
	b.NOTE             AS detNote,
	b.PRO_CHECK_DET_ID AS proCheckDetId,
	b.DETAIL           AS detail 
FROM
	TBZPROFI_CHECK as a left join 
	TBZPRO_CHECK_DET as b  on
	a.PROFI_CHECK_ID=b.PROFI_CHECK_ID
 where 
	a.BRANCH_ID = 'c47774beb01343b5baa2f97c98569d9b'
ORDER BY
	createTs

呵呵一定不要忘记带了