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.

Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release ...

If you plan to do database development with Java and MySQL, the first thing you’ll need to do is configure a database schema. Technically speaking, the first thing to do before you configure a schema ...