不好意思~~問個簡單的問題.. Select a.name , b.name From table_a a LEFT OUTER JOIN table_b b ON a.id = b.id 在Oracle上執行這一段查詢會有錯誤~~ [SQL Command not properly ended at Line 2] 可是也不能寫成 Select a.name , b.name From table_a a , table_b b Where a.id *= b.id 到底該怎麼寫呢??

Andy Wu 你好: 試試: Select a.name , b.name From table_a a , table_b b Where a.id = b.id ( )

引言: Andy Wu 你好: 試試: Select a.name , b.name From table_a a , table_b b Where a.id = b.id ( )

可以啦~~~ 謝謝 ~~