請問sql語法中之LEFT OUTER JOIN用法，若使用兩個鍵應如何使用 select c1,c2,... from A LEFT OUTER JOIN B ON(A.QUO_NO = B.CON_NO) LEFT OUTER JOIN C ON(A.QUO_CUST = C.CU_NO) And (B.CON_PROD = C.PD_NO) 其中 C需有兩鍵對應取資料 謝謝

用accset是好像不能直接join,只好用sub select ========================================== select * from (SELECT t1.test_no,t3.test_no2 FROM (t1 LEFT JOIN t3 ON t1.test_no = t3.test_no)) as a LEFT JOIN t2 ON (a.test_no = t2.test_no) AND (a.test_no2 = t2.test_no2); ==================================