pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedJoin operations
2+ messages / 2 participants
[nested] [flat]
* Join operations
@ 1999-06-18 00:25 Tim Holloway <mtsinc@southeast.net>
0 siblings, 0 replies; 2+ messages in thread
From: Tim Holloway @ 1999-06-18 00:25 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: [SQL] Join operations
@ 1999-06-18 15:16 Jackson, DeJuan <djackson@cpsgroup.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jackson, DeJuan @ 1999-06-18 15:16 UTC (permalink / raw)
To: Tim Holloway <mtsinc@southeast.net>; pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-06-18 15:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-18 00:25 Join operations Tim Holloway <mtsinc@southeast.net>
1999-06-18 15:16 RE: [SQL] Join operations Jackson, DeJuan <djackson@cpsgroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox