as u can see at room no 109 there is no customer
and its on first floor
in my db design , room and floor are fixed for the hotel
so what wud be the query to insert customer in room no 109
along with RentDate,LeavingDate,Contract
pls pls let me know asap
thx in advance
imti
roomno...