List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:July 27 2006 12:07am
Subject:Re: JOIN table where not in other table
View as plain text  
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.
>   

Attachment: [text/html]
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
Thread
JOIN table where not in other tablePeter Lauri27 Jul
  • Re: JOIN table where not in other tableChris White27 Jul
    • RE: JOIN table where not in other tablePeter Lauri27 Jul
      • Re: JOIN table where not in other tableChris White27 Jul
        • RE: JOIN table where not in other tablePeter Lauri27 Jul
          • Re: JOIN table where not in other tableChris White27 Jul
            • RE: JOIN table where not in other tablePeter Lauri27 Jul
              • Re: JOIN table where not in other tableChris White27 Jul
                • RE: JOIN table where not in other tablePeter Lauri27 Jul
              • Re: JOIN table where not in other tablePeter Brawley27 Jul