表A(主表)、B(从表)关联字段fid表B
id fid fid
---------------------
1 1 2
2 2 1
3 1 1表A
id name
---------------------
1 tom
2 jon查询出结果
B.id A.name A.name
---------------------
1 tom jon
2 jon tom
3 tom tom
id fid fid
---------------------
1 1 2
2 2 1
3 1 1表A
id name
---------------------
1 tom
2 jon查询出结果
B.id A.name A.name
---------------------
1 tom jon
2 jon tom
3 tom tom
这里面去找找看,sql常用语句集锦
---建立数据
declare @t1 table (id int,name nvarchar(10))
declare @t2 table (id int,fid1 int,fid2 int)
insert @t1 values(1,'tom')
insert @t1 values(2,'jon')
insert @t2 values(1,1,2)
insert @t2 values(2,2,1)
insert @t2 values(3,1,1)
---查询
select t2.id,t1.[name],t3.[name] from @t1 t1,@t2 t2,@t1 t3
where t2.fid1=t1.id and t2.fid2=t3.id order by t1.id