SELECT a.*, b.* FROM a, b WHERE a.c=b.c
UNION ALL
SELECT a.*, NULL, NULL, ... WHERE NOT EXISTS(SELECT 1 FROM b WHERE a.c=b.c);
Hope this helps,-DEJ
> -----Original Message-----
> From: Tim Holloway [SMTP:mtsinc@southeast.net]
> Sent: Thursday, June 17, 1999 7:26 PM
> To: pgsql-sql@postgreSQL.org
> Subject: [SQL] Join operations
>
> Until the true SQL JOIN clauses become operative are there equivalents in
> the existing PostgresSQL SQL? I'm particularly interested in LEFT OUTER
> JOIN.
>
> TIA,
> Tim Holloway