SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

Practical .NET Speed Up Your Application with Stored Procedure and Temporary Tables Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL ...

Both examples are relevant to both DBs. The first example is what I'm trying to do: combine the contents of two tables using a subquery. This works fine in SQL Server but not in MySQL.