List:General Discussion« Previous MessageNext Message »
From:Chris White Date:July 26 2006 10:36pm
Subject:Re: JOIN table where not in other table
View as plain text  
On Wednesday 26 July 2006 10:31 am, Peter Lauri wrote:
> Best group member,
>
> I just made up this query, but let us work from this:
>
> SELECT * FROM table1
> LEFT OUTER JOIN table2 ON (table1.id=table2.id)
> WHERE table2.prop IS NULL;

If I understand correct:

SELECT * FROM table 1
WHERE id NOT IN
(SELECT id FROM table2);

-- 
Chris White
PHP Programmer/DBacardi
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