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
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...
Show quoted text
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
Import Notes
Resolved by subject fallback
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?