Maybe, but did you check the result? I got a lot of rows don't want to see
and still don't got "2nd" ...
Jonathan Lewis wrote in message
<938430027.3922.0.nnrp-03.9e984b29_at_news.demon.co.uk>...
>
>You lost the 'null row' by joining it to
>the KEYS table. You need -
>
>>select main.id, addon, title
>>from keys, main, title
>>where keys.num(+) = main.id
>>and title.type = 1
>>and main.tid(+) = title.id;
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>Gerard van Dorth wrote in message
><938428729.26294.0.pluto.d4ee362b_at_news.demon.nl>...
>
>>select main.id, addon, title
>>from keys, main, title
>>where keys.num = main.id
>>and title.type = 1
>>and main.tid(+) = title.id;
>>
>>We expected the result:
>>1, First, Mr.
>>2, Second, (null)
>>3, Third, Miss
>>(like we had in our SQL-server applic (with a different OJ syntax))
>>Can someone explain us why the result: "2, Second, (null)" is missing
>>running this query on Oracle (7.3.3.xxx) ... and how to query to get what
>we
>>expected?
>>
>
>
>
Received on Mon Sep 27 1999 - 07:35:14 CDT
