Looks pretty much like the solution I gave. Anyway, you might want to consider using "UNION ALL" instead of "UNION". Mike
On Fri, Oct 31, 2008 at 3:44 AM, Vlad <[EMAIL PROTECTED]> wrote: > > Actually - now a few days on I've found a further solution which > involves a bit of both. One thing to point out is that the > application that uses the SQL can replace the code [FILTER] with the > internal ID of the object your looking up that makes this a bit > easier. > > Here I go - in my system we have objects of type A or B - the query > could be passed either of these objects. > > SELECT Info1,Info2 FROM Table1 > WHERE Table1.ID = '[FILTER_CODE]' > AND type='A' > ) > UNION > SELECT Info1,Info2 FROM Table2 > WHERE Table2.ID = '[FILTER_CODE]' > AND type='B' > > As the object can only ever be one type and this is either A or B - if > the object is A , the query returns the first results, if it is type B > then it is the second results. > > Hope this makes sense > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
