Re: SQL Help!

Kathy Holley wrote:
>
> Is there a simple way of doing this:
> 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.
>
> Thanks in advance for your help!

Suggestion:

	select decode(descr,
		null,	<language1 desc>,
		descr)
	from table...
	where ....

Mike Krolewski Received on Wed Jul 24 1996 - 00:00:00 CEST