I need to execute an 'outer join' in a Baan script. Using the normal SQL syntax, I get a compile error 'not expected'. Does embedded Baan not follow standard SQL syntax? How do you code a 'left outer join' in a Baan embedded sql statement?

Can you please post your SQL statement .

Regards,
Niraj

Hi,

Check this link where this issue was discussed:
http://www.baanboard.com/baanboard/showthread.php?t=54136&highlight=outer+join

I hope it helps,

- George

Thank you George, and Niraj. I ended up having to break up the sql statements using the values in 'selectdo' and 'selectempty'.

Regards,
Jim