Re: Help With A Select

>route available capacity
>
>11 1200 3000
>11 1400 2000
>11 900 5000
>
>I wrote the following query that returns '900', but how can I get the '5000'
>that goes along with it?
>
>SELECT route, MIN(available)
>FROM table_a
>WHERE route=11
>GROUP BY route;
>

select * from table_a where (route,available) in (select route, MIN(available)

     from table_a WHERE route=11 GROUP BY route);

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html