急！求SQL语句

[friendly_2008]

表结构如下

create table t1
(
id int,
name varchar(20)
)




create table t2
(
id int,
address varchar(20)
)

insert into t1 values(1,'a')
insert into t1 values(2,'b')
insert into t1 values(3,'c')


insert into t2 values(1,'aa')
insert into t2 values(1,'bb')
insert into t2 values(3,'cc')


--select * from t1
--select * from t2

所得到结果

id name address
----------- --------------------
1 a aa
2 b
3 c

[hlq8210]

SELECT T1.id,T1.Name,T2.Address
from t1 left join t2
on t1.id=t2.id

[Yisa]

create function kkmerg(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+address from (select t1.id, t2.address from t1 left join t2 on t1.id=t2.id) a where id=@id
set @str=stuff(@str,1,1,'')
return(@str)
End



select id, name, dbo.kkmerg(id) from t1 group by id, name

[Yisa]

结果是:

id name address
----------- --------------------
1 a aa, bb
2 b null
3 c cc

[filebat]

id name address
----------- --------------------
1 a aa
2 b
3 c
？
这个结果集是按什么标准产生的？

[friendly_2008]

问题已经解决，谢谢大家

标准是
1对多 关系 只随便取多 的那边的一条记录

[skyboy1977]

楼上的什么意思，我不太明白，能写出来吗，我也想知道最后的答案！！