Re: JOIN table where not in other table

Wed, 26 Jul 2006 17:08:01 -0700

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:[EMAIL PROTECTED]] 
Sent: Thursday, July 27, 2006 6:05 AM
To: mysql@lists.mysql.com
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.
  
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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to