内部连接三个表
问题描述:
我有三个表我希望通过它们之间的共同列进行内部连接。内部连接三个表
说我的表是;
TableA TableB TableC
我想加入A-B
,但随后也B-C
所有通过这个共同的领域我会打电话常见。
我已经加入了两张这样的表格;
dbo.tableA AS A INNER JOIN dbo.TableB AS B
ON A.common = B.common
如何添加第三个?
答
select *
from
tableA a
inner join
tableB b
on a.common = b.common
inner join
TableC c
on b.common = c.common
答
dbo.tableA AS A INNER JOIN dbo.TableB AS B
ON A.common = B.common INNER JOIN TableC C
ON B.common = C.common
答
只是做同样的事情,但阿恩则表C
SELECT *
FROM dbo.tableA A
INNER JOIN dbo.TableB B ON A.common = B.common
INNER JOIN dbo.TableC C ON A.common = C.common
答
试试下面的代码
select * from TableA A
inner join TableB B on A.Column=B.Column
inner join TableC C on A.Column=C.Column
答
试试这个:
SELECT * FROM TableA
JOIN TableB ON TableA.primary_key = TableB.foreign_key
JOIN TableB ON TableB.foreign_key = TableC.foreign_key
dbo.tableA一个S A INNER JOIN dbo.TableB AS B ON A.common = B.common内部连接dbo.TableC作为C上C.common = B.common – praveen 2012-08-06 08:01:36