Re: Multi-table Join Condition

From: Alexander Kuznetsov <Alexander.Kuznetsov_at_marshmc.com>
Date: 27 Oct 2002 18:52:16 -0800
Message-ID: <ac5bc7c1.0210271852.4f316041_at_posting.google.com>


Hi,
SELECT
table1.col1 as Column1,

T2.ColZ as Column2,
T3.ColZ as Column3,
T4.ColZ as Column4,
T5.ColZ as Column5

FROM
Table1, Table2,
Table3 AS T2, 
Table3 AS T3,
Table3 AS T4, 

Table3 AS T5
WHERE
Table1.Col2 = Table2.ColA
AND Table2.ColB = T2.ColY
AND Table2.ColC = T3.ColY
AND Table2.ColD = T4.ColY
AND Table2.ColE = T5.ColY
Received on Mon Oct 28 2002 - 03:52:16 CET

Original text of this message