Re: MIN value from a column in 2 tables.

> select * from
> (
> select min(ID) as ID, 'table1' as this_table from table1
> union all
> select min(ID) as ID, 'table2' as this_table from table2
> )
> where ID =
> select min(ID) from (select * from table1 union select * from table2);

Thanks again - appreciated.

Mark Received on Tue Jan 21 2003 - 03:00:54 CST