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`) );
select teste01.id_01, teste02.id_002, teste03.id_003 from teste01 inner join teste02 on 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];
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)