Re: QUESTION LEFT OUTER JOIN

From: John Oliver <John_at_yellowstone.co.uk>
Date: Mon, 24 Aug 1998 13:46:34 +0100
Message-ID: <35E160AA.3FD0F22F@yellowstone.co.uk>

Dominick LoGiudice wrote:
>
> Can I do a left outer join query using two queries
> something like this?
> If yes how would I fix the query below to work?
>
> SELECT z.name_level,z.name_set, z.name_key,
> z.name_selected
> FROM z
> LEFT OUTER JOIN
> SELECT y.name_level + 1 AS NEXTLEVEL, y.name_set,
> y.name_key,
> y.name_selected
> FROM y
> ON y.name_level = x.name_level;

SELECT z.name_level,z.name_set, z.name_key, z.name_selected

	y.name_level + 1 AS NEXTLEVEL, y.name_set,
        y.name_key,
        y.name_selected
        FROM z, y

WHERE y.name_level (+) = z.name_level

gives you Zs even when no Ys exist.

OR
WHERE y.name_level = z.name_level (+)

gvies you Ys even when no Zs exist.

--
Regards,
John. Received on Mon Aug 24 1998 - 07:46:34 CDT