QUESTION LEFT OUTER JOIN

From: Dominick LoGiudice <dlogiudice_at_pine.vpcc.sunysb.edu>
Date: Sun, 23 Aug 1998 23:00:18 -0400
Message-ID: <35E0D742.12AEB493@pine.vpcc.sunysb.edu>

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; Received on Sun Aug 23 1998 - 22:00:18 CDT