我如何关于三个表的内部联接。 [英] How do I a inner join about three tables.

问题描述

 CREATE TABLE`Teste01`（
`id_01`INTEGER，
`id_02`INTEGER，
 PRIMARY KEY（`id_02`）
）; 

创建表`Teste02`（
`id_001`INTEGER，
`id_primary `INTEGER，
 PRIMARY KEY（`id_primary`）
）; 

< ; pre> CREATE TABLE`Teste03`（
`id_003`INTEGER，
`id_primary`INTEGER，
 PRIMARY KEY（`id_primary`）
）; 

我的尝试：

选择teste01.id_01，teste02.id_002，teste03.id_003，来自teste01内部连接teste02，来自teste01.id_01 = teste02.id_primary; 

那么，我如何使用三个表进行内连接？



谢谢。

解决方案

  SELECT  t1。[id_01] 
，t2。[id_002] 
，t3。[id_003] 
  FROM  [dbo]。[Teste01] t1 
  LEFT   JOIN  [dbo]。[Teste02 ] t2  ON  t2。[id_primary] = t1。[id_01] 
  LEFT   JOIN  [dbo]。[Teste03] t3  ON  t3。[id_primary] = t1。[id_02]; 

CREATE TABLE `Teste01` (
	`id_01`	INTEGER,
	`id_02`	INTEGER,
	PRIMARY KEY(`id_02`)
);

CREATE TABLE `Teste02` (
	`id_001`	INTEGER,
	`id_primary`	INTEGER,
	PRIMARY KEY(`id_primary`)
);

<pre>CREATE TABLE `Teste03` (
	`id_003`	INTEGER,
	`id_primary`	INTEGER,
	PRIMARY KEY(`id_primary`)
);

What I have tried:

select teste01.id_01, teste02.id_002, teste03.id_003 from teste01 inner join teste02 on teste01.id_01=teste02.id_primary; 

So, how I make a inner join with three tables?

Thanks.

解决方案

SELECT t1.[id_01]
     , t2.[id_002]
     , t3.[id_003]
  FROM [dbo].[Teste01] t1
    LEFT JOIN [dbo].[Teste02] t2 ON t2.[id_primary] = t1.[id_01]
    LEFT JOIN [dbo].[Teste03] t3 ON t3.[id_primary] = t1.[id_02];

这篇关于我如何关于三个表的内部联接。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！