Welcome to OTN forms
For example:select * from a, b where a.no=b.no(+)select * from a, b where a.no left outer join b.noThank you
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.