Question

SQL 两个表联查

table1表只有个ID字段
table2表有ID和CASH字段
第一个表值是1,2,3,4,5
第二个表是
1,100
3,500

要查到的结果是
1,100
2,0
3,500
4,0
5,0

谢谢啦 很简单的 之前会 突然想不起来了 麻烦帮下

Answer 1

SELECT table1.ID, table2.CASH FROM table1 LEFT OUTER JOIN table2 ON table1.ID=table2.ID

Answer 2

额 左连接
select * from table2 left join table1 on table1.ID=table2.ID
好像是这样，不对的话就换成right join 我自己也有点分不清

Answer 3

select T2.*
from T1, T2
where T1.ID = T2.ID
UNION
select ID, 0
from T1
where ID not in (select distinct ID form T2)
ORDER BY 1

Answer 4

select table1.id,nvl(table2.cash,0)
from table1,table2
where table1=table2(+)

Answer 5

select b1.ID,isnull(b2.CASH,0) from table1 b1 left join table2 b2 on b1.ID=b2.ID