Help With A Select

Given the following table

table_a

route available capacity

11           1200            3000
11           1400            2000
11            900            5000

I need a query that will return a single row that has the minimum available value of the three rows and the corresponding capacity.

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;

Any help would be appreciated ASAP!

Brian Received on Wed Jul 23 1997 - 00:00:00 CDT