The only way would be to write one query for each table, and then UNION them
together. However, that would only work if you returned exactly the same
number of fields in each subquery, plus there's a limit as to how many
subqueries you can UNION together.
No single query can do so, unless as Douglas suggests all the tables
have the same structure.
Why would you EVER want to do this? In a properly normalized database,
each table contains a distinct type of data. Searching for addresses
in a table maintenance history table would simply make no sense!
