Re: MIN value from a column in 2 tables.

> This should do it:
>
> select min(ID) from (select * from table1 union select * from table2);

Thank you.

Additional: how would I identify which table the row is from?

Thanks,

Mark Received on Tue Jan 21 2003 - 02:32:04 CST