Re: PostgreSQL Outer Joins

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Outer Joins
Date: 2001-12-10 18:48:19
Message-ID: 003201c181ab$3d020da0$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL Outer Joins> Does PostgreSQL 7.1.3 support outer joins; or do you
still need to use subqueries?

Yes, outer joins are supported.

> If it does support outer joins, does anyone know the syntax?

ANSI SQL.

Example:
SELECT * FROM T1 LEFT JOIN T2 ON T1.ID=T2.ID;

Greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nick Fankhauser 2001-12-10 18:52:23 Re: PostgreSQL Outer Joins
Previous Message Robert B. Easter 2001-12-10 18:47:06 Re: PostgreSQL Outer Joins