左连接查询

SELECTa.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 FROMTBZPROFI_CHECK as a left join TBZPRO_CHECK_DET as b  ona.PROFI_CHECK_ID=b.PROFI_CHECK_ID where a.BRANCH_ID = 'c47774beb01343b5baa2f97c98569d9b'ORDER BYcreateTs

呵呵一定不要忘记带了