SELECT C_QUEM_QNASID,C_QUEM_QUEMID,C_QUEM_QCLASS1
FROM QUEMNGTBL LEFT OUTER JOIN CODDEFTBL ON C_QUEM_QCLASS1=C_CODD_CODE
WHERE C_CODD_CODE='0001'
这样写结果不对!!!
FROM QUEMNGTBL LEFT OUTER JOIN CODDEFTBL ON C_QUEM_QCLASS1=C_CODD_CODE
WHERE C_CODD_CODE='0001'
这样写结果不对!!!
FROM QUEMNGTBL RIGHT OUTER JOIN CODDEFTBL ON C_QUEM_QCLASS1=C_CODD_CODE
left join (select '0001' as fie from dual) c on C_QUEM_QCLASS1=fie
FROM QUEMNGTBL RIGHT OUTER JOIN (SELECT * FROM CODDEFTBL WHERE
C_CODD_KIND='0001' ) AS C_CODD1 ON C_QUEM_QCLASS1=C_CODD1_CODE;
试试看!!!
FROM QUEMNGTBL a LEFT JOIN CODDEFTBL B ON a.C-QUEM_QCLASS1 = b.C_CODD_CODE AND
B.C_CODD_KIND = '0001'
最后正确结果:
select C_QUEM_QNASID, C_QUEM_QUEMID,C_QUEM_QCLASS1,C_CODD_CONT
FROM QUEMNGTBL LEFT JOIN CODDEFTBL ON C_QUEM_QCLASS1 = C_CODD_CODE AND C_CODD_KIND = '0001'beckhambobo(beckham)能否说说原因???
C_CODD_KIND = '0001' == C_CODD_KIND(+)='0001'