Airport table SlNo Name Code Auth Location status 1 Chennai CHN Yes India 1 2. Hydarabed HYD Yes India 0 3 walker WAK Yes uk 1
common table SlNo Name Code Type Location status 1 Chennai CHN Airport India 1 2. guest Road GR Seaport India 1 3. Hyderabad HYD Airport India 0 4. John garden JG Seaport India 0 5 walker WAK airport uk 1 Hi All Can u please tell the query for the above table , Display the record which satisfy below condtions , 1.Need to display airport name , Where airport status = 1 and common table status = 1 and common table type = airport Output somthing like below AirportCode CommonCode AirportSlNo CommonSlNo AirportName CommonLocation Status Type CHN CHN 1 1 Chennai india 1 airport WAK WAK 3 5 walker uk 1 airport Any idea ,,,,,,,,, Thnaks -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org