About 'left outer join'
akane0331 26 Jun 2012 00:53
I want to know how to make query with Peoplesoft.
' select mainT.field1,SubT.fields3 from MainTbl mainT left outer join
(select sub.field1,sub.field3 from SubTbl sub where sub.field2 is null) SubT
on mainT.field1 = SubT.field1 '
I want to get all information in MainTbl.
I have tried to make with 'exists', but result was as same as following SQL.
' select mainT.field1,SubT.fields3 from MainTbl mainT left outer join
SubTbl SubT where SubT.field2 is null'
on mainT.field1 = SubT.field1 '
That result is a information including MainTbl and SubTbl .
I want to get information although SubTbl has not information.
Sorry my poor English.
Regards.