Re: PostgreSQL Outer Joins - Mailing list pgsql-general

From Gregory Wood
Subject Re: PostgreSQL Outer Joins
Date
Msg-id 003201c181ab$3d020da0$7889ffcc@comstock.com
Whole thread Raw
In response to PostgreSQL Outer Joins  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List 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


pgsql-general by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: problem with select after updating
Next
From: "Robert B. Easter"
Date:
Subject: Re: PostgreSQL Outer Joins