Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA37367 for ; Fri, 18 Jun 1999 11:17:08 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id KAA01040; Fri, 18 Jun 1999 10:17:01 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma001001; Fri, 18 Jun 99 10:16:52 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Fri, 18 Jun 1999 10:16:47 -0500 Message-ID: From: "Jackson, DeJuan" To: Tim Holloway , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Join operations Date: Fri, 18 Jun 1999 10:16:47 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain 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