SELECT
A.PTY_NAME,
A.PTY_TYP,
A.PTY_ID,
B.SOL_NAME,
B.SOL_ID,
B.LF_FRNO,
C.ACT_DESC,
E.LF_NAME
FROM
VEFS_DOCP_HC A,
VEFS_ACTS_HC C,
VEFS_DOCDTL_HC D,
VEFS_LFIRM_HC E
LEFT JOIN VEFS_DOCPSOL_HC B ON
A.PTY_TYP = B.PTY_TYP AND
A.DOC_ID = B.DOC_ID
WHERE
A.PTY_TYP IN ('HCDR','HCDN') AND
D.DOC_ID = A.DOC_ID AND
C.ACT_CODE = D.ACT_CODE AND
B.LF_CODE=E.LF_CODE AND A.DOC_ID=B.LF_CODE AND
A.DOC_ID = '395112'
试试
A.PTY_NAME,
A.PTY_TYP,
A.PTY_ID,
B.SOL_NAME,
B.SOL_ID,
B.LF_FRNO,
C.ACT_DESC,
E.LF_NAME
FROM
VEFS_DOCP_HC A,
VEFS_ACTS_HC C,
VEFS_DOCDTL_HC D,
VEFS_LFIRM_HC E
LEFT JOIN VEFS_DOCPSOL_HC B ON
A.PTY_TYP = B.PTY_TYP AND
A.DOC_ID = B.DOC_ID
WHERE
A.PTY_TYP IN ('HCDR','HCDN') AND
D.DOC_ID = A.DOC_ID AND
C.ACT_CODE = D.ACT_CODE AND
B.LF_CODE=E.LF_CODE AND A.DOC_ID=B.LF_CODE AND
A.DOC_ID = '395112'
试试
A.PTY_TYP = B.PTY_TYP AND
A.DOC_ID = B.DOC_ID 的位置有问题!!!
====〉
FROM
VEFS_DOCP_HC A LEFT JOIN VEFS_DOCPSOL_HC B ON
A.PTY_TYP = B.PTY_TYP AND
A.DOC_ID = B.DOC_ID ,
VEFS_ACTS_HC C,
VEFS_DOCDTL_HC D,
VEFS_LFIRM_HC E
where
……