很简单的两张表，要求写出 SQL 语句，解决就送分，时间紧迫！！

[khler]

两张表如下：
t1{f1[char],f2[int]} t2{f3[char],f1[char]}
A 6 X A
B 7 Y B
A 10 Z C

结果：
X 16
Y 7
Z 0

要求写出SQL语句得到如上结果。

[wwwwb]

select t2.f3,iif(isnull(sum(t1.f2)),0,sum(t1.f2)) from t2 inner join t1 on t1.f1=t2.f1

[wwwwb]

select t2.f3,iif(isnull(sum(t1.f2)),0,sum(t1.f2)) from t2 inner join t1 on t1.f1=t2.f1
group by t2.f3

[wjpath23]

---------------
create table t1(f1 char(10),f2 int)
insert into t1
select 'A',6
union all
select 'B',7
union all
select 'A',10
create table t2 (f3 char(10),f1 char(10))
insert into t2
select 'X','A'
union all
select 'Y','B'
union all
select 'z','C'
------------
select sum(isnull(dbo.t1.f2 ,0)) as b,dbo.t2.f3
from dbo.t1 full outer join dbo.t2
on dbo.t1.f1 = dbo.t2.f1
group by dbo.t2.f3

[wjpath23]

---------------
create table t1(f1 char(10),f2 int)
insert into t1
select 'A',6
union all
select 'B',7
union all
select 'A',10
create table t2 (f3 char(10),f1 char(10))
insert into t2
select 'X','A'
union all
select 'Y','B'
union all
select 'z','C'
------------
select sum(isnull(dbo.t1.f2 ,0)) as b,dbo.t2.f3
from dbo.t1 full outer join dbo.t2
on dbo.t1.f1 = dbo.t2.f1
group by dbo.t2.f3
------------
---------------
create table t1(f1 char(10),f2 int)
insert into t1
select 'A',6
union all
select 'B',7
union all
select 'A',10
create table t2 (f3 char(10),f1 char(10))
insert into t2
select 'X','A'
union all
select 'Y','B'
union all
select 'z','C'
------------
16 X
7 Y
0 z

[我自横刀香甜笑]

select t2.f3,
isnull((select sum(f2) from t1 where t1.f1=t2.f4),0) as f5
from t2

[khler]

echeng192，过来领取

[WeekWant]

select t1.f3[char],isnull(count(f2[int]),'0') from t1 inner join t2 where t1.f1[char] = t2.f1[char] order by t1.f3[char]

[WeekWant]

不好意思,color=#FF0000]order by t1.f3[char][[/color], 应该为group by t1.f3

[liuyufeng]

select sum(isnull(t1.f2 ,0)),t2.f3
from t1 full outer join t2 on t1.f1 = t2.f1

[lovemegigi]

select t2.f3, isnull((select sum(f2) from t1 where t1.f1=t2.f4),0) as f5 from t2

[zhou969]

select t2.f3,isnull((select sum(f2) from t1 where t1.f1=t2.f4),0)
from t2