请教一个左连接问题SELECT *FROM table1 t1 LEFT OUTER JOIN table2 t2ON t1.a t2.cORDER BY t1.a如果t1
请教一个左连接问题
SELECT *
FROM table1 t1 LEFT OUTER JOIN table2 t2
ON t1.a = t2.c
ORDER BY t1.a
如果t1.a，t2.c都是null，怎么关联起来？
[解决办法]
JUST TRY IT ..
- SQL code
SELECT * FROM TABLE1 T1 LEFT OUTER JOIN TABLE2 T2 ON NVL(T1.A, 0) = NVL(T2.C, 0) ORDER BY T1.A;