Обсуждение: NULL fields in inner join

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

--
[]'s,

Fernando Braga
VCNet Ltda.
Maceió (AL), Brazil
fernando@vcnet.com.br
+55 (82) 336-2079

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