my project is of hotel booking..

Question

I have two tables room and room booking....room tables fields are roomid,hotelname,roomtype,roomdescription,roomfacility,roomphoto and roomprice And roombooking fields are clientname,hotelname,checkindate,checkoutdate,noofroom,noavailableroom,price I want search is there any data room available.. And it's new project so roombooking has no data So plz help in query