how to use left outer join in oracle forms .
Welcome to OTN forms
What version of Oracle Forms are you using? The "Oracle" outer join will work in all versions of Forms, however, the "ANSI" LEFT OUTER JOIN will not. It is always a good idea to list your Forms version when posting a question.