Select from table, name is stored in the field

How can I join some data from some table whose name is a field of the dataset?

Like this:

SELECT *
 FROM dataset
 INNER JOIN dataset.table_name 
 ON dataset.param_id = (dataset.table_name).id_(dataset.table_name)
 

---