Re: SQL question

If you mean which description is equal to TOR for the min value:

select distinct description1, description2, number from table
where number = ( SELECT MIN(number)

                 FROM    table
                 WHERE  description1 = 'TOR' or description2 = 'TOR' )

--
Have a nice day
Michel


Curt Ingram <cingramb_at_bigfoot.com> a écrit dans le message :
Vxvo4.12743$Mk2.520212_at_newsread2.prod.itd.earthlink.net...


> given the following query,


>

> SELECT MIN(number)

> FROM    table

> WHERE  description1 = 'TOR' or description2 = 'TOR';

>

> is there a clean way to know which side of the 'or' statement was satisfied

> ?

>

> Thanks,

> Curt

>

>

>