Re: MIN value from a column in 2 tables.

> I would rather do it like this:
>
> SELECT
> *
> FROM (
> 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 )
> ORDER BY id DESC
> )
> WHERE rownum = 1
>
> This way, tables 1 and 2 are only hit once.

Thank you - excellent! Received on Tue Jan 21 2003 - 08:59:41 CST