declare @t1 table(id int,en varchar(20)) insert into @t1 select 1,'test' declare @t2 table(id int,cn varchar(20)) insert into @t2 select 1,'测试' select t1.id,t1.EN+','+t2.CN as name from @t1 t1 left join @t2 t2 on t1.id=t2.id/* id name --------------------------------- 1 test,测试 */
Select A.ID, A.EN + ',' + B.CN As NAME From 表1 A Inner Join 表2 B On A.ID = B.ID:)
Select a.Id,a.En+','+b.Cn As Name From 表1 a Inner Join 表2 b Where a.Id=b.Id
insert into @t1
select 1,'test'
declare @t2 table(id int,cn varchar(20))
insert into @t2
select 1,'测试'
select t1.id,t1.EN+','+t2.CN as name from @t1 t1
left join @t2 t2 on t1.id=t2.id/*
id name
---------------------------------
1 test,测试
*/
表1 a Inner Join 表2 b
Where a.Id=b.Id