SQL Query Guidance required

[ee12csvt]

I have a number of pages that read information from different tables in the database to create the page. All these tables have a 'created' and 'updated' field which is populated with timestamps when records are created or updated.

SELECT updated FROM tableA ORDER BY updated DESC
SELECT updated FROM tableB ORDER BY updated DESC
SELECT updated FROM tableC ORDER BY updated DESC

I want to display when the page was last updated, so need to pull the 'updated' fields from the tables used on that page, sort them in desc order.

Would "SELECT updated FROM tableA, tableB, tableC ORDER BY updated DESC" work?

Is there a MySQL function that could perform this action, or is there another way to do it?

[ixalmida]

Can you get to the "information_schema" schema?

If so, you could just run this query:

SELECT UPDATE_TIME FROM `information_schema`.`TABLES`
WHERE TABLE_SCHEMA = 'SchemaName' AND TABLE_NAME IN ('tableA', 'tableB', 'tableC')
ORDER BY UPDATE_TIME DESC