How do i make an outer join, which qptool can parse it. Can any one give an example.Thank you
Regards
Ramesh

Ramesh,

I have not tried this stuff with qptool. But here is the general gist about joins.

Baan uses the datadictionary to determine if joins are equal or left outer.
reference mode in dd UNREF mode
mandatory SETUNREF
mandatory unless empty CLEARUNREF
not mandatory CLEAR

It is possible to override these settings with the unref clause in the "refers to" of the select statements.

See the "References" section in the "Baan SQL" help topic for a detailed explanation of the subject.

Hi Vamsi,
Thank you for the reply. I looked into the Baan Help for those references which is helpful in getting my query done.