Hi Friends,


In SQL, feature of Left Outer Join, Right Outer Join etc. is provided.
Is this feature present in BaaN ?

Thanx and Regards,
Rahul.

The outer Join functionality is not present in Baan. You have to program the select of the join between the selectdo/endselect. if the tables are referenced than you have the possibility to outer join with the refer to statement.

Han

I learnt sql programming with Baan. So I am not familiar with the general terminology. I was under the impression so far that outer joins as mentioned generally were the same as selects in Baan with the "unref" clause. Could someone throw more light on this?