MIN value from a column in 2 tables.

Hello,

I'm trying to write some code to select the MIN value from a column which exists separately in 2 tables. The table structure is the same but the data is different.

E.g. table 1:

ID Name
---- ----

10 Smith
11 Jones

table 2:

ID Name
---- ----

1 Bloggs
12 Chang

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

Any suggestions as how to do this?

Thanks,

Mark Received on Mon Jan 20 2003 - 11:08:05 CST