"Campano, Troy" <Troy.Campano@LibertyMutual.com> writes:
> Does PostgreSQL 7.1.3 support outer joins; or do you still need to use
> subqueries?
Yes, it supports outer joins.
> If it does support outer joins, does anyone know the syntax?
Same syntax as the SQL standard I think (as opposed to Oracle's which
is nonstandard). See the docs:
http://www.us.postgresql.org/users-lounge/docs/#7.1
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863