Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with outer join in Oracle 9.2
gkorea_at_verizon.net schreef:
> Hi everyone, I am having trouble with an sql I am writing -- I have 2
> tables that I want to get info from, in some cases there will be data
> in one but not in the other but I still want the query to work -- that
> is an outer join but whichever way I try I can't get any data to
> return -- can anyone help maybe I am just missing something -- I am on
> AIX running oracle 9.2 -- I have listed the sql below
>
>
> Thanks in advance
>
> Jerry
>
> SELECT
> LAWSON.QUARTDED.EMPLOYEE,LAWSON.QUARTDED.DED_CODE,
> LAWSON.QUARTDED.DED_AMT,
> LAWSON.PRWEEKS.NBR_WEEKS
> FROM
> LAWSON.QUARTDED left join LAWSON.PRWEEKS on lawson.quartded.employee =
> lawson.pr
> weeks.employee
> WHERE
> LAWSON.QUARTDED.DED_CODE in ('PAUC') AND
> LAWSON.QUARTDED.PAYROLL_YEAR = '2006' and
> LAWSON.QUARTDED.QUARTER = '4' and
> LAWSON.PRWEEKS.QUARTER = '4' and
> LAWSON.PRWEEKS.PAYROLL_YEAR = '2006' and
> LAWSON.QUARTDED.EMPLOYEE = '160006'
>
> By the way -- data will exist in the quartded file but not in prweeks
> -- I want prweeks to return null
>
Discard my post - overlooked the left join (which isn't a left outer join)
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Mar 26 2007 - 13:12:23 CDT