[SQL ] Oracle join兩個table

[wildpeanut (B級的人生)]

一般來說要用left join兩個table 通常是用
SELECT A1.store_name, A1.id, A1.card, A2.sale, A2.history
FROM Georgraphy A1, Store_Information A2
WHERE A1.store_name = A2.store_name(+)

我的問題是現在這兩個table需要用兩個欄位store_name, id 作連結
寫成這樣會有問題
SELECT A1.store_name, A1.id, A1.card, A2.sale, A2.history
FROM Georgraphy A1, Store_Information A2
WHERE A1.store_name = A2.store_name(+)
AND A1.id = A2.id(+)

請問我要怎麼下SQL語法

請告訴我~感謝

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 61.218.95.154