left outer join on same table

[sagar naik]

Hi ,

I am trying to do join on same table.
I wanted to do a left outer join
However, the results are not like left outer join( with no null values)

select T1.field1, T1.field2, T1.field3
          T2.field10
          from table T1
          left outer join table T2 on (T1.key=T2.key and
T1.partition='p1' and T2.partition='p2')
           where
           T1.field5='xxxxx' and T2.field6='yyyyyyy;'


I tried left/full  all join result are like  inner join.
What am I missing here ?
 is it some mistake on my part or some optimization /flag to be turned off

Thanks for the help



-Sagar