MYSQL question: how to display titles from all blogs

So, the goal is a page that dynamically displays all the names and descriptions from the dozen or so blogs in my database. The problem is that the table prefixes on my blogs are all different.

Is there a MySQL query that let’s me call the blogname without having to do a “FROM” command that lists each table name? I want the blog list to update dynamically whenever a blog is added or deleted from the database. Is there a do a FROM command on all tables?