How to write this SQL Query (Hotels, Rooms, and Rates)? ... Also looking at your schema I'm not sure I'm doing the right thing with date searched.<BR><BR>But there you have it in a nut shell ...