***这个sql怎么写？***

Question

select id,name,bid,bname from a,b
where a.bid=b.bid(+);

Answer 1

15:49:03 SQL> select * from t1;        ID       NAME        BID
---------- ---------- ----------
         1          1          1
         2          3          4
         5          6
         3          8
         4          2已用时间:  00: 00: 00.00
15:49:07 SQL> select * from t2;       BID      BNAME
---------- ----------
         1          6
         2          3
                    6已用时间:  00: 00: 00.16
15:49:09 SQL> select a.id,a.name,a.bid,b.bname from t1 a,t2 b where a.bid=b.bid(
+);        ID       NAME        BID      BNAME
---------- ---------- ---------- ----------
         1          1          1          6
         2          3          4
         5          6
         3          8
         4          2

Answer 2

--9i后的版本可以用join了，左连接：
select a.id,a.name,a.bid,b.bname
from A表 a 
left join B表 b 
on a.id = b.id