Stuff snipped ... comment at end On Mar 23, 3:37 pm, "mike.arsenault" <[email protected]> wrote: > > ----------------------------------------------------------------------------------------------------- > SELECT * > FROM (OQ.omclassrel o > LEFT OUTER JOIN OQ.omrelationtype o2 ON o.RelType_oi=o2.rltypoi) > WHERE > > (o.dmcroi <> 1000037465 OR o.dmcroi IS NULL ) > > AND > > o2.rltypoi=?
am I missing something or isn't it true that o and o2 are out of scope in the where clause because that just looks odd to me. Not to mention that it is pretty tortured syntax to start with. I am not seeing the point of the parens around the first bit. Or is that an odbc quirk? Rob --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
