[Lucas]

I want to select a row from two different tables, and I want the one row that is selected to have the latest time that was inserted into the database. So, like say row1 in table1 has a timestamp of 1050303 and row2 in table2 has a timestamp of 10505050. I only want row2, the one with the latest time stamp, to be selected. Is there anyway to do this in one query, and if not, can you show me how to do it anyway? Thanks

[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...