Its not really a perl question, more the way your DB engine works.

The only method i can think of is using a subquery, and fudging it that way, altho' you need the table structure to support what you need.

I guess it doesnt exist, because, you already must know the table_name you want in order for you to run a query against it. For the db engine to supply the information to you that you already have would be double handling.