Selecting one greatest number from two columns?

[Sugapablo]

I have table1 and table2.
In table1 I have a column of numbers, numbers1.
In table2 I have a column of numbers, numbers2.

I'd like to select the highest number represented in either column.

Example:

table1:column1
--------------
3
45
5656
43
6565
556
76

table2:column2
--------------
34
5
6
5645
564
56456
456
456
The number I would want would be 56456 since it's the largest number
out of all combined.

How can I get that number with one select statement?

--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]

[L. Bertolini]

Maybe:

select max(x)
from

(
select x=max(column1) from table1
union
select x=max(column2) from table2
) u

Sugapablo wrote:

I have table1 and table2.
In table1 I have a column of numbers, numbers1.
In table2 I have a column of numbers, numbers2.

I'd like to select the highest number represented in either column.

Example:

table1:column1
--------------
3
45
5656
43
6565
556
76

table2:column2
--------------
34
5
6
5645
564
56456
456
456
The number I would want would be 56456 since it's the largest number
out of all combined.

How can I get that number with one select statement?