can anyone pls help me out to make the query like.. if two tables have some comman records then how to find records from one table that are not in another table.
eg...
i have one table room type master (room_type_m)
fields : room_type_id, room_type_name and other details
and another table hotel room type relation (hotel_rtype_r) fields : hotel_id and room_type_id and some other fields this table will contain multiple room_type_ids for one hotel_id
i want to print those room_type_id (from room_type_m) that are not present in relation table ie .(hotel_rtype_r)
regards, Smita
_________________________________________________________________
It's all happening @ F1. Feel the thrill! http://server1.msn.co.in/sp03/formula2003/index.asp Race along right here!
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
