retrieve data from multiple tables referencing some tables in mysql
- by I Like PHP
i have 10 tables have innoDB engine
1. one is state_table which attributes are state_id and state_name
2. another table city_table which attributes are city_id and city_name
3. one more table permit_table which attribute is p_id
above city_id,state_id and permit_id is references to rest of 7 tables.
each table having state_id, city_id and…