Re: MIN value from a column in 2 tables.

Hallo Mark,

> I need to identify that the MIN value of ID is 1.

You could try something like this:

select min(one) from
(select min(id) as one from table1
union
selecct min(id) as one from table2)

Ciao Thomas Received on Mon Jan 20 2003 - 11:57:00 CST