请教一SQL语句

[yangsanshao]

有A，B表。A表记录如下
seq account_id account_name balace
1 1001 100
2 1001 200
3 1001 100
4 1002 150
5 1002 100
B表如下：
account_id account_name
1001 现金
1002 银行
请问如何写SQL语句实现下表显示
seq account_id account_name balace
1 1001 现金 100
2 1001 200
3 1001 100
4 1002 银行 150
5 1002 100

[bzszp]

select * from a,b where a.account_id=b.account_id(+);

[whan1234]

easy.

select a.seq,
a.account_id,
b.account_name,
a.balace
from
a,b
where
a.account_id=b.account_id(+)
;

[xinpingf]

这个在sqlplus下可以实现

SQL> break on account_name
SQL> select a.seq,a.account_id,b.account_name,balace
from a, b where a.account_id=b.account_id;

[ruyuezhang]

select a.seq,a.account_id,b.account_name,a.balace from a,b
where (a.seq,a.account_id )in (select min(seq) seq,account_id from a group by account_id)
and a.account_id=b.account_id
union
(select seq,account_id,account_name,balace from a
where (seq,account_id) not in (select min(seq) seq,account_id from a
group by a.account_id))
order by seq

[wwl007]

ruyuezhang(ruyue) ( ) 信誉：100 绝对同意你的观点

[yangsanshao]

谢谢各位