Re: SQL Help!
From: Kathy Holley <kholley_at_kti.com>
Date: 1996/07/24
Message-ID: <31F65294.54AD_at_kti.com>#1/1
Date: 1996/07/24
Message-ID: <31F65294.54AD_at_kti.com>#1/1
> I think this should work (I'm not where I can test it):
>
> select decode(count(table2.desc),0,table1.desc,table2.desc)
> from my_table table1, my_table table2
> where table1.language = 1
> and table2.language = 2
Thanks for your help, although I couldn't get your suggestion to work, I received another one which worked fine. Thanks anyway. Kathy Received on Wed Jul 24 1996 - 00:00:00 CEST