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.

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.

YourSQL supports activation of some of the more advanced features of MySQL such as indices, without requiring advanced technical knowledge from the users, according to MacTech magazine .