Full outer join giving only left outer join
Posted on 2004-03-28
I Have the following query getting some budgetdetails(gl00201) and the associated actual amounts of that specifc year and date from (gl00110),i have given a fuller outer join on the common keys between the gl00201 and gl00110 ,but still the output am getting is the left outer join,gl00102 is the table from where i am getting the accounts description. kinldy Let me know what is the problem with this query.
SELECT distinct GL00100.actdescr "ACCTDESC100", GL00100.actINDX "ACTINDX100",
GL00102.ACCATDSC "ACCDES102", gl00102.ACCATNUM "ACCAT102",
ISNULL(GL00201.BUDGETAMT,0.00)BUDGETAMT, gl00201.accatnum "BUDCATNUM",gl00201.ACTINDX "BUDGETIN
D",gl00201.periodid [BudgetPeriodid],gl00201.BUDGETID [Budgetid],
ISNULL(GL10110.PERDBLNC,0.00) CURRENTAMT,GL10110.YEAR1 CURRENTYR,gl10110.accatnum "CURRENTCATNUM",gl10110.ACTINDX "ACTAMTIND", GL10110.PERIODID ACTPERID
(( GL00102 LEFT OUTER JOIN GL00100 ON GL00102.ACCATNUM = GL00100.ACCATNUM
LEFT OUTER JOIN GL00201 ON GL00201.ACTINDX=gl00100.ACTINDX and GL00102.ACCATNUM=GL00201.ACCATNUM
and budgetid ='budget3' and GL00201.periodid Between 0 and 3) FULL OUTER JOIN GL10110 ON GL00102.ACCATNUM =
GL10110.ACCATNUM and gl10110.year1='2000'
and GL10110.periodid Between 0 and 3 and gl00201.actindx=gl10110.actindx and gl00201.PERIODID=gl10110.PERIODID)
gl00102.accatnum between 1 and 30
order by gl00102.accatnum,GL00100.ACTINDX