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
Hello list
I have a problem. I have 4 tables (in Mysql 3.23). All of them have a filed
named cod.
I want a query to find which cod of table1, table2, table3 is/are not in
table4.
cod values in table1, table2, table3 are diferent.
Thank you
Nikos
--
MySQL General Mailing List
For list archives
Join many table with 1 query is the ideal. Because you must sure that
there are the valid data integrity. If there is only 1 broken join key
(any part of table1.key=table2.key), you'll got the null row. When you
need to display all of the first table value and retrieve another
information
Can anyone tell me a more efficient way to structure this query? It
works fast enough now, but I don't have that much data yet. I am
concerned with future performance.
I need all of the rows from the project table that match the first where
clause. The other information saves me from having to
