在php mysql中查找具有相似名称的多个表

I'm trying to select data from two mysql tables using Join but I'm wanting to select from several tables with similar names such as profile_starter, profile_advanced, profile_premium, etc. My question is how can I select from the other tables without having to join more tables? I've tried * but it doesn't work:I'm trying to select data from two mysql tables