Thread: joinning tables

hi,

it seems like postgresql does not interpret a LEFT JOIN instruction like
other sql engines. for exemple, if it have some null values on keys, data
tables are not joinned... same has if it was a INNER JOIN instruction.

any idea?

thanks
=> send me your answer on esaracco@aspasia.fr

On Wed, 12 Sep 2001, Emmanuel SARACCO wrote:

> hi,
>
> it seems like postgresql does not interpret a LEFT JOIN instruction like
> other sql engines. for exemple, if it have some null values on keys, data
> tables are not joinned... same has if it was a INNER JOIN instruction.

Can you give an example of what you're seeing?

Outer joins are supported in PostgreSQL, but not before version 7.1.
If you are using version 7.1, please post your failing query, and someone
will be able to help you.

"Emmanuel SARACCO" <emmanuel.saracco@d-interactive.com> wrote in message
news:9nnjc3$68p$1@news.tht.net...
> hi,
>
> it seems like postgresql does not interpret a LEFT JOIN instruction like
> other sql engines. for exemple, if it have some null values on keys, data
> tables are not joinned... same has if it was a INNER JOIN instruction.
>
> any idea?
>
> thanks