Get Max() value between two tables

[james0816]

What is the best way to get the maximum value of a "like" field in two tables?

(I.e.

Table1 - Field1 - Values: 0002, 0003, 0005
Table2 - Field1 - Values: 0001, 0005 )

Result should be: 0005

 

[r937]

select max(field1) as max_field1
  from (
       select field1
         from table1
       union
       select field1
         from table2
       ) as u

r937.com | rudy.ca