List:General Discussion« Previous MessageNext Message »
From:Peter Lauri Date:July 26 2006 6:00pm
Subject:RE: JOIN table where not in other table
View as plain text  
The query in full was exactly as you wrote it (but without the typo) :)

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

On Wednesday 26 July 2006 10:53 am, Peter Lauri wrote:
> I tried that, but that generates:
>
> #1064 - You have an error in your SQL syntax.  Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'SELECT id FROM table2)
> LIMIT 0, 100' at line 1

What's the full query look like right now (btw, there was a typo earlier,
that 
should have been table1 and not table 1 :/)?
-- 
Chris White
PHP Programmer/DBarkTree
Interfuel

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