Businesses can utilize MySQL to streamline processes and efficiently manage structured data. Users can perform queries, or requests, via MySQL to access information stored to a database. Sometimes ...

and a.RoomType = b.RoomType; </pre><BR>I believe that's SQL92. Its my understanding that MySQL doesn't support all of SQL92 - specifically I don't know how it deals with temp tables.