22,207
社区成员
发帖
与我相关
我的任务
分享
Select #A.id,#A.name,#B.name AS Bname from #A JOIN #B ON cid=#B.id WHERE #A.id=1
$row['Bname']
SELECT A.*,B.* FROM A
LEFT OUTER JOIN B on A.cid = B.id
Select #A.id,#A.name,#B.name from #A JOIN #B ON cid=#B.id WHERE #A.id=1
--测试数据
if not object_id(N'Tempdb..#A') is null
drop table #A
Go
Create table #A([id] int,[name] nvarchar(22),[cid] int)
Insert #A
select 1,N'张三',11 union all
select 2,N'李四',12
GO
if not object_id(N'Tempdb..#B') is null
drop table #B
Go
Create table #B([id] int,[name] nvarchar(22))
Insert #B
select 11,N'教师' union all
select 12,N'学生'
Go
--测试数据结束
Select #A.id,#A.name,#B.name from #A JOIN #B ON cid=#B.id