Thread: Left Joins

How can I use LEFT JOINS with postgresql?

Is there a command to do LEFT JOINS with postgresql?

Thanks
--
Francisco Eriko Barreto Brito
Adm Banco de Dados
Grupo Radix
Tel: (55 81) 3271-6232
eriko@radix.com.br
www.radix.com.br

Francisco Eriko Barreto Brito <eriko@radix.com.br> writes:

> How can I use LEFT JOINS with postgresql?
>
> Is there a command to do LEFT JOINS with postgresql?

Yes, if you're running 7.1 or later.  See the docs.

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm.    -Dylan

http://www.postgresql.org/idocs/index.php?sql-select.html

----- Original Message -----
From: "Francisco Eriko Barreto Brito" <eriko@radix.com.br>
To: <pgsql-general@postgresql.org>
Sent: Monday, September 17, 2001 3:22 PM
Subject: [GENERAL] Left Joins


> How can I use LEFT JOINS with postgresql?
>
> Is there a command to do LEFT JOINS with postgresql?
>
> Thanks
> --
> Francisco Eriko Barreto Brito
> Adm Banco de Dados
> Grupo Radix
> Tel: (55 81) 3271-6232
> eriko@radix.com.br
> www.radix.com.br
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>