一段SQL语句,会者不难,难者不会啊

[haonanernet]

表A:

Aid name
1 a
2 b
3 c
4 d
5 e

表B:

Bid name color
1 a '红'
1 b '绿'
3 b '蓝'
4 a '蓝'
4 b '红'
4 c '黄'


想得到:
name color
a '蓝'
b '红'
c '黄'
d ''
e ''
就是想查出Bid=等于4的记录

但是name又要调出A中所有name的值

[paoluo]

试试

Select A.Name,IsNull(B.color,'') from 表A A
Left Join 表B B On A.Name=B.Name And Bid=4

[_谁啊]

SELECT name, ISNULL
((SELECT color
FROM 表B
WHERE bid = 4 AND name = 表A.name), '''''') AS color
FROM 表A

[sh_zll]

select name,color from b where Bid='4'
union
select name,'' from a where a.name not in(select name from b where Bid='4')

[jihanzhong]

左连接

[Well]

Select A.Name,isnull(B.color,'') from 表A A
Left Join 表B B On A.Name=B.Name And Bid=4

[heguosheng]

总结一下：
上面三位的结果都对

个人推荐 paoluo(一天到晚游泳的鱼)的