From: Peter Brawley Date: July 27 2006 12:07am Subject: Re: JOIN table where not in other table List-Archive: http://lists.mysql.com/mysql/200335 Message-Id: <44C803CD.1080806@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-44C803CD33D4=======" --=======AVGMAIL-44C803CD33D4======= Content-Type: multipart/alternative; boundary=------------010900070000060409010507 --------------010900070000060409010507 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Peter >feels strange to JOIN tables and >choose rows where the join value is NULL (left outer join) :) It's standard SQL and has a name, "exclusion join". Not a bit more "strange" than counting wot's missing. PB Peter Lauri wrote: > 4.0.27, so that is probably the reason. Any other way then with a sub query? > I solved it with my "stupid" solution, feels strange to JOIN tables and > choose rows where the join value is NULL (left outer join) :) > > -----Original Message----- > From: Chris White [mailto:chriswhite@stripped] > Sent: Thursday, July 27, 2006 6:05 AM > To: mysql@stripped > Subject: Re: JOIN table where not in other table > > On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote: > >> The query in full was exactly as you wrote it (but without the typo) :) >> > Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here > and that works just fine. > --------------010900070000060409010507 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Peter

>feels strange to JOIN tables and
>choose rows where the join value is NULL (left outer join)  :)

It's standard SQL and has a name, "exclusion join". Not a bit more "strange" than counting wot's missing.

PB

Peter Lauri wrote:

4.0.27, so that is probably the reason. Any other way then with a sub query?
I solved it with my "stupid" solution, feels strange to JOIN tables and
choose rows where the join value is NULL (left outer join) :)

-----Original Message-----
From: Chris White [mailto:chriswhite@stripped] 
Sent: Thursday, July 27, 2006 6:05 AM
To: mysql@stripped
Subject: Re: JOIN table where not in other table

On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:

The query in full was exactly as you wrote it (but without the typo) :)

Alright, yes, what is your version of MySQL?  I'm in the 5.0.22 series here 
and that works just fine.

--------------010900070000060409010507-- --=======AVGMAIL-44C803CD33D4======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 7/25/2006 --=======AVGMAIL-44C803CD33D4=======--