I noticed that sometimes when I hit the REPLY button on Gmail, it does a reply to the group and other times it just replies directly to the person. I think in this case, my missing post went directly to your personal email account. I'll have to be more careful about that in the future. Not that it matters now, but here is a copy of what I had posted: -------------------------------------------------------------------------- x:='TypeA';
SELECT 'carinfo' table_nam, make, model, NULL area, NULL colour FROM carinfo WHERE x = 'TypeA' UNION ALL SELECT 'houseinfo' table_nam, NULL make, NULL model, area, colour FROM houseinfo WHERE x != 'TypeA'; you would need to tweak this, but you get the idea. -------------------------------------------------------------------------- Regards, Mike On Sat, Nov 1, 2008 at 5:46 AM, Vlad <[EMAIL PROTECTED]> wrote: > > Hi Michael, > > Sorry if I'm missing something but I didn't see a post from you on > this thread - or are you refering to one of my other posts? > > Thanks > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
