Select record Details and its own table count in select statements where Each record have its own table

Select record Details and its own table count in select statements where
Each record have its own table

I have a table with recordid ,record name, and an extra column with its
corresponding Table name. Each record have its own table . Now I want to
select record name , id and its corresponding table count using select
query in sql. Please help me ..
Thank You