I think to answer both of your questions, the SQL syntax is generated from a framework that we use, so I don't have a lot of control on the generated results. I guess I could generate NVL() in ORACLE or ISNULL () in SQLServer and see if that fixes the problem. As far as the brackets around the LEFT OUTER JOIN, this is only about 10% of the original query - so I removed quite a few of the other tables that were joined in and I may have left in the brackets that would otherwise not be required.
Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
