On Tuesday, September 18, 2001, at 06:23 AM, Francisco Eriko Barreto
Brito wrote:
> How can I use LEFT JOINS with postgresql?
>
> Is there a command to do LEFT JOINS with postgresql?
>
Upgrade to 7.1 (7.1.3 is the latest I think)
this allows you to use syntax like:
SELECT y.bar, x.foo
FROM tbly y
LEFT JOIN tblx x ON x.id = y.xid
==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au