Re: [GENERAL] Negating the list of selected rows of a join

[Clark Evans]

Manuel Lemos wrote:
> How can I make a query that works the way I want all the time, even for the
> case when table_b is empty?

SELECT table_a.name, table_a.age 
  FROM table_a
 WHERE NOT EXISTS ( 
          SELECT 'x' 
            FROM table_b
           WHERE table_b.name = table_a.name 
       );


Hope this will do the trick.

:) Clark Evans