pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Join 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