[sufyan]

Best I can think of at the moment is:

PHP Code:

mysql> SELECT MAX(table1.timestamp), MAX(table2.timestamp) FROM table1, table2;

+-----------------------+-----------------------+

| MAX(table1.timestamp) | MAX(table2.timestamp) |

+-----------------------+-----------------------+

|        20040626031407 |        20040626031424 |

+-----------------------+-----------------------+

1 row in set (0.00 sec) 

and then use PHP to compare the two values and output the greater value. But there *might* be a better way to do it with just SQL. Maybe someone can figure it out...