Re: [GENERAL] Negating the list of selected rows of a join - Mailing list pgsql-general

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