这样的需求,sql怎么写!
tb_user
id name
1 ua
2 ub
3 uc
4 ud
5 ue
============
tb_record
id userid record
1 1 A
2 2 B
3 3 C
4 5 E
=======================想得到以下这样的集怎么写name record
ua A
ub B
uc C
ud NULL(或空植均可)
ue E
======= 注:ud无纪录,但在选择结果集里就显示NULL(或空植均可)!
tb_user
id name
1 ua
2 ub
3 uc
4 ud
5 ue
============
tb_record
id userid record
1 1 A
2 2 B
3 3 C
4 5 E
=======================想得到以下这样的集怎么写name record
ua A
ub B
uc C
ud NULL(或空植均可)
ue E
======= 注:ud无纪录,但在选择结果集里就显示NULL(或空植均可)!
Oracle:
select t1.name,
t2.record
from tb_user t1,
tb_record t2
where t1.id = t2.userid(+)