Hi all

Does anyone know if outer join will work in baan?

That's the (+) in oracle db.

thanx

d.

For all I know, Baan doesn't do outer joins, left joins or any other fancy stuff. You'll have to work your way around it with
'not exists (select ...)' type constructions.

You can do outer joins in Baan, but it is very restrictive. It involves using the REFERS TO operator and it can only be used to reference the primary key. The other alternative is to use the SELECTEMPTY to perform another action.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.