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.

MySQL Autopilot uses advanced machine learning techniques to accelerate HeatWave query performance and scalability in Oracle Cloud’s MySQL Database Service.