List:General Discussion« Previous MessageNext Message »
From:Peter Lauri Date:July 26 2006 6:30pm
Subject:RE: JOIN table where not in other table
View as plain text  
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.
-- 
Chris White
PHP Programmer/DBackItUp
Interfuel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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