一个有关文本相加的问题

[kenlong]

我有两个表
A:
name tel address
ken 00 guangzhou

B:
name desc
ken 000000
ken 111111

现在我想输出以下结果,用sql语句怎样实现
ken 00 guangzhou 000000/111111

请各位大哥指教

[ReViSion]

Create function Fun_AA(@name varchar(50))
returns varchar(500)
as
begin
Declare @re varchar(500)
set @re=''

select @re=@re+'/'+rtrim(ltrim(desc)) from B where
name=@name

if len(@re)>0 select @re=left(@re,len(Re)-1)
return(@re)
end

select * ,dbo.fun_aa(name) from A