Hi all
*country* ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country&sql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASC&token=48055f87d08d88620138b58feb711be2> Name<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country&sql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60Name%60+ASC&token=48055f87d08d88620138b58feb711be2> Tel_Code<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country&sql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60Tel_Code%60+ASC&token=48055f87d08d88620138b58feb711be2> ActiveInd<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country&sql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ActiveInd%60+ASC&token=48055f87d08d88620138b58feb711be2> 103 India 91 1 104 Indonesia 62 1 105 Iran 98 1 106 Iraq 964 1 *city* *ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=city&sql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60ID%60+ASC&token=48055f87d08d88620138b58feb711be2> * *Name<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=city&sql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60Name%60+ASC&token=48055f87d08d88620138b58feb711be2> * *ActiveInd<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=city&sql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60ActiveInd%60+ASC&token=48055f87d08d88620138b58feb711be2> * 1 chennai 1 2 mumbai 1 3 pattaya 1 *country_city* *ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country_city&sql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60ID%60+ASC&token=48055f87d08d88620138b58feb711be2> * *City_ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country_city&sql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60City_ID%60+ASC&token=48055f87d08d88620138b58feb711be2> * *Country_ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country_city&sql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60Country_ID%60+ASC&token=48055f87d08d88620138b58feb711be2> * *ActiveInd<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country_city&sql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60ActiveInd%60+ASC&token=48055f87d08d88620138b58feb711be2> * 1 1 103 1 2 2 103 1 3 3 216 1 Hi can i want the query which display the below output *Cityname | countryname | cityid | countryid* chennai | india | 1 | 103 mumbai | india | 2 | 103 Can u please the query ,