KCRKD1_PJLX KCRKD1_LSBH KCRKD1_DJRQ KCRKD1_KCYWRQ KCRKD1_CHYWRQ KCRKD1_SJDH KCRKD1_LBBH KCRKD1_CKBH KCRKD1_DWBH KCRKD1_DDBH KCRKD1_JHBH KCRKD1_BMBH KCRKD1_ZGBH KCRKD1_JKY KCRKD1_FZR KCRKD1_BGY KCRKD1_LRXM KCRKD1_SFJCHZ KCRKD1_BZ KCRKD1_ZJDH KCRKD1_SHLC KCRKD1_SHBZ KCRKD1_SHRQ KCRKD1_SHXM KCRKD1_CGJZ KCRKD1_SFCZGJ KCRKD1_CGRQ KCRKD1_KCJZ KCRKD1_CHJZ KCRKD1_CHXM KCRKD1_FPHX KCRKD1_CYFPHX KCRKD1_CXBZ KCRKD1_QCBZ KCRKD1_HDBZ KCRKD1_CXBH KCRKD1_ZGBZ KCRKD1_PZRQ KCRKD1_PZNM KCRKD1_PZND KCRKD1_PZBH KCRKD1_DYPERSON KCRKD1_DYDATE KCRKD1_YWBS KCRKD1_LYBH KCRKD1_SCDH KCRKD1_CJJZ KCRKD1_CJRQ KCRKD1_CJXM KCRKD1_CBBZ KCRKD1_DCBZ KCRKD1_DWGC KCRKD1_KCXGSJ KCRKD1_CHXGSJ KCRKD1_KCJZSJ KCRKD1_CHJZSJ KCRKD1_SFQR KCRKD1_KCXM KCRKD1_ZJFX KCRKD1_C1 KCRKD1_C2 KCRKD1_C4 KCRKD1_C3 KCRKD1_C5 KCRKD1_C6 KCRKD1_C7 KCRKD1_C8 KCRKD1_C9 KCRKD1_C10 KCRKD1_U1 KCRKD1_U2 KCRKD1_U3 KCRKD1_U4 KCRKD1_U5 KCRKD1_U6 KCRKD1_YLZZS KCRKD1_DDJSF KCRKD1_HWTGF KCRKD1_SKF KCRKD1_KPF KCRKD1_ZFYW KCRKD1_SCFLAG KCRKD1_FCBZ
上面的是表头的列
KCRKD2_PJLX KCRKD2_LSBH KCRKD2_FLBH KCRKD2_WLBH KCRKD2_TSKC KCRKD2_XGDX KCRKD2_DDLS KCRKD2_DDFL KCRKD2_DHLS KCRKD2_DHFL KCRKD2_JHLS KCRKD2_JHFL KCRKD2_CGDDLS KCRKD2_CGDDFL KCRKD2_WTDDFL KCRKD2_JHBH KCRKD2_YSSL KCRKD2_SSSL KCRKD2_HLSH KCRKD2_DJ KCRKD2_JE KCRKD2_JHDJ KCRKD2_JHJE KCRKD2_HSDJ KCRKD2_SL KCRKD2_SE KCRKD2_HSJE KCRKD2_FYSSL1 KCRKD2_FYSSL2 KCRKD2_FSSSL1 KCRKD2_FSSSL2 KCRKD2_PCH KCRKD2_HWBH KCRKD2_ZYX1 KCRKD2_ZYX2 KCRKD2_ZYX3 KCRKD2_ZYX4 KCRKD2_ZYX5 KCRKD2_WLZT KCRKD2_WLBZ KCRKD2_HXSL KCRKD2_HXDJ KCRKD2_HXJE KCRKD2_CLJE KCRKD2_JGJE KCRKD2_YZJE KCRKD2_WTCBBZ KCRKD2_ZJZT KCRKD2_ZJJL KCRKD2_CLFS KCRKD2_ZJWC KCRKD2_JSSL KCRKD2_BGDH KCRKD2_BZ KCRKD2_ZLDH KCRKD2_FYSSL3 KCRKD2_FSSSL3 KCRKD2_RKJLLS KCRKD2_RKJLFL KCRKD2_SCDDLS KCRKD2_SCDDFL KCRKD2_C1 KCRKD2_C2 KCRKD2_C3 KCRKD2_C4 KCRKD2_C5 KCRKD2_C6 KCRKD2_C7 KCRKD2_C8 KCRKD2_C9 KCRKD2_C10 KCRKD2_U1 KCRKD2_U2 KCRKD2_U3 KCRKD2_U4 KCRKD2_U5 KCRKD2_U6 KCRKD2_XSXH KCRKD2_CXLS KCRKD2_CXFL KCRKD2_THSL KCRKD2_THFSL1 KCRKD2_THFSL2 KCRKD2_CGDDBH KCRKD2_GBDLS KCRKD2_GBDFL KCRKD2_TMH KCRKD2_XXH KCRKD2_HXHSJE KCRKD2_GZZX KCRKD2_GXBH KCRKD2_GXLSBH KCRKD2_PXBZ KCRKD2_CLCBBZ
上面是表体的列 也就是入库单的明细
两个用KCRKD2_LSBH KCRKD1_LSBH关联 、KCRKD2_PJLX='G'的是采购入库单
SELECT * from KCRKD1_PJLX A
LEFT JOIN KCRKD2_PJLX B ON B.KCRKD2_LSBH=A.KCRKD1_LSBH
WHERE B.KCRKD2_PJLX='G'