How to write this SQL Query (Hotels, Rooms, and Rates)? ... Its my understanding that MySQL doesn't support all of SQL92 - specifically I don't know how it deals with temp tables.