AIL PROTECTED]>
To: "? ??" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "Brent Baisley" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 2:38 PM
Subject: Re: joining 4 tables
> Hi,
>
> You need to use UNION, but it's not possi
ley" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 1:15 PM
Subject: Re: joining 4 tables
Thank you all for replying.
Brent your code is nice but I'ts not what I want.
In "where" clause the equality is not true because its table has diferent
cod fields anyway.
Can you
TED]>
To: <$B&-&)&*&/&2 (B $B&#&!&3&2&'&2(B <[EMAIL PROTECTED]>)>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 3:43 PM
Subject: Re: joining 4 tables
> SELECT table4.cod, table1.cod, table2.cod, table3.cod
SELECT table4.cod, table1.cod, table2.cod, table3.cod
(BFROM table4
(BLEFT JOIN table1 ON table4.cod=table1.cod
(BLEFT JOIN table1 ON table4.cod=table2.cod
(BLEFT JOIN table1 ON table4.cod=table3.cod
(BWHERE table1.cod IS NULL
(BAND table2.cod IS NULL
(BAND table3.cod IS NULL
(B
(BI think
