菜鸟2问,大家帮忙(1)
1.
(1)我有一个表1
ID NAME
1 JIM
2 DAVID
(2)我有表2
LID ID LANGUAGE
1 1 JAVA
2 1 .NET
3 2 JAVA
4 2 VB
我想在GRIDVIEW中这样显示
ID NAME JAVA .NET VB
1 JIM 1 1 0
2 DAVID 1 0 1
求解决方案
[解决办法]
select distinct(b.id) ID,a.name NAME,SUM(case when b.language=JAVA then 1 else 0 end) as JAVA,SUM(case when b.language=.NET then 1 else 0 end) as .NET,SUM(case when b.language=VB then 1 else 0 end) as VB
FROM 表1 a left join 表2 b on a.id=b.id
[解决办法]
帮顶
[解决办法]
up
[解决办法]
用临时表
[解决办法]
select distinct(b.id) as id,a.name as name,
sum(case when b.language= 'java ' then 1 else 0 end) as java,
sum(case when b.language= 'vb ' then 1 else 0 end) as vb,
sum(case when b.language= '.net ' then 1 else 0 end) as net
FROM 表1 a left join 表2 b on a.id=b.id group by a.name ,b.id
上面都是错的.
