Re: outerjoin - "where is Second"

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 - 05:52:48 CDT