Regarding: "The issue is: the above and similar queries are generated automatically, the same code (query) is used in MySQL, Postgrees and Oracle AND, as it is not my code that generates these expressions, I cannot modify the generating code of these queries."
I don't mean to be pessimistic, but do you think your current problem with LEFT OUTER JOIN might be the tip of the iceberg? There are so many vendor-specific SQL syntax variations that I hope this isn't merely the first problem of many. [Pessimistic opinions are my own, not those of my company nor its board of directors.] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------