Is it possible to have a conditional from statement:- E.g.
Select * from ( select case WHEN TypeTBL.Type = 'TypeA' then select make,model from CarInfo Else Select Area,Colour from HouseInfo END ) TypeTBL I know there are other ways of writing this (by putting the case statement into the select part of the query) but this method would be better in my situation if possible. TIA --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
