这样的结果如何处理?

[rongxh]

我用FULL OUTER JOIN连接两表,得出的数据是这样的:
GL178 8000.00 NULL NULL
GT122 8000.00 NULL NULL
NULL NULL CT133 10000.00

如何才能够得出这样的结果呢?

GL178 8000.00 CT133 10000.00
GT122 8000.00 NULL NULL

[good2speed]

用LEFT JOIN

[lalakid]

left join

[chinaandys]

楼主结贴: left join连接

[rongxh]

不行吧,如果是用LEFT JOIN,那么得出的结果是这样的吧:
GL178 8000.00 NULL NULL
GT122 8000.00 NULL NULL

[rongxh]

没人回答吗？

[lsxaa]

给出表结构?

[lsxaa]

关联条件?

[rongxh]

原始表:
table1:
col1 col2
A 120
B 200
A 100
C 100
Table2:
col1 col2
B 110
B 100
C 120
结果:
Col1 Col2 Col3 Col4
A 220 B 210
B 200 C 120
C 100 null null

[rongxh]

UP

[lenghuazhang]

create talbe #t1 (a identity(1,1) int,b char(10),c int)
create talbe #t2 (a identity(1,1) int,b char(10),c int)

insert into #t1 select col1,sum(col2) from table1 group by col1 order by col1
insert into #t2 select col1,sum(col2) from table2 group by col1 order by col1

select #t1.b as col1,#t1.c as col2,#t2.b as col3,#t2.c as col4 from #t1 left join #t2 on
#t1.a=#t2.a

drop table #1
drop talbe #2

[rongxh]

结果不对吧?

[chinaandys]

select id=identity(int,1,1),col1,col2=sum(col2) into #t1 from table1 a group by col1
go
select id=identity(int,1,1),col1 as col3,col4=sum(col2) into #t2 from table2 group by col1
go
select a.col1,a.col2,b.col3,b.col4 from #t1 a left join #t2 b
on a.id=b.id
go


A 220 B 210
B 200 C 120
C 100 NULL NULL

[chinaandys]

select id=identity(int,1,1),col1,col2=sum(col2) into #t1 from table1 a group by col1
go
select id=identity(int,1,1),col1 as col3,col4=sum(col2) into #t2 from table2 group by col1
go
select a.col1,a.col2,b.col3,b.col4 from #t1 a left join #t2 b
on a.id=b.id
drop table #t1,#t2
go


A 220 B 210
B 200 C 120
C 100 NULL NULL