RE: [SQL] Join operations

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(at)southeast(dot)net]
> Sent: Thursday, June 17, 1999 7:26 PM
> To: pgsql-sql(at)postgreSQL(dot)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