Toad Edge delivers many of the outstanding productivity-boosting features that we’re known for – making it easier than ever for developers and DBAs to ramp-up and transition to MySQL.” ...

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.