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.

Fastest Way to Check if MYSQL Table Exists in PHP. Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query.

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.