How to correct the can't reopen table error in MySQL?

Question

there is a problem coming and i'm not able to run multiple select statements in one query. please guide me how to solve it.

Answer 1

Nest your select statements. select from tableName where Conditions, select from table2Name where Conditions 2 etc, or use joins.