> I have a table with id column, another id (id2) column and a value
> column. For each id there can be more id2. I want id2 for id where
> the value is min.
> thanks sjors
select distinct id2 from tab
where id=x and value = (select max(value) from tab where id=x)
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com