關於Oracle中左連接的問題.大家help me.
在Oracle中可以這樣左聯:
select tableA.A1,tableA.A2,tableB.B1,tableB.B2
from tableA,tableB where tableA.A1 = tableB.B1(+)
and tableB.B2(+)='a';
那如果我要在tableB.B2後用in,那左聯該怎麼寫:
select tableA.A1,tableA.A2,tableB.B1,tableB.B2
from tableA,tableB where tableA.A1 = tableB.B1(+)
and tableB.B2 in ('a','b');