左连接查询

最新推荐文章于 2024-07-22 16:08:56 发布

舞动de人生

最新推荐文章于 2024-07-22 16:08:56 发布

阅读量1.5k

点赞数

本文链接：https://blog.csdn.net/dongwujing/article/details/8225842

版权

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

呵呵一定不要忘记带了