Merging Tables with MySQL Merging tables, called "joining" in MySQL terms, is done by using the MySQL command interface in phpMyAdmin to create a new table.

And that’s all there is to creating a table and inserting data into it on MySQL. Once you have all the data necessary, your database is ready for usage by your web-based tool.

How to Sequence Names in MySQL. Sequences in MySQL help ensure that values aren't repeated, and many applications require database tables to have an incrementing "id" column. The MySQL syntax ...

In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.