SQL Help!
From: Kathy Holley <kholley_at_kti.com>
Date: 1996/07/23
Message-ID: <31F55250.790C_at_kti.com>#1/1
Date: 1996/07/23
Message-ID: <31F55250.790C_at_kti.com>#1/1
Is there a simple way of doing this:
Thanks in advance for your help!
My table has 2 column: Language, desc
I need to select desc where Language = 2, if no rows are returned, then I
need to select desc where Language = 1;
(Language =1 is the default and will always be there)
I wrote one select statement to do it, but it seems a bit complicated, I
use 1 sub-select with 'EXIST' and one union.
I am sure there must be a better way to do it without having to check for
nulls and sending a second query.