Re: NULL fields in inner join

From: dev+pgsql(at)humph(dot)com
To: Fernando Braga <fernando(at)vcnet(dot)com(dot)br>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: NULL fields in inner join
Date: 2003-01-21 09:14:28
Message-ID: a05200f09ba52bf998a6d@[10.0.1.15]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

At 15:57 -0200 2003/01/15, Fernando Braga wrote:
>Hi Guys,
>
>If i run an INNER JOIN through odbc, all NULL fields are retrieved with
>values (??!). And worse of that, when this occurs, the lines with NULL
>fields comes three times.
>
>Of course, when I do the SQL on the linux server, it comes correct
>
>Have anybody experienced this behaviour ?
>
>I've attached linux_server.txt and xp_client.jpg
>

sorry, but first you are doing an outer join, second the two queries
seem to have the same results except for the ordering (as the order
by is not the same).
So, what's wrong?

g

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Jim 2003-01-21 22:54:05 SSL, Crypt in ODBC
Previous Message Dave Page 2003-01-21 08:32:11 Re: Schema in ODBC table names