mysql - union self with temporary table -

Not working with the same floating table, but it works the same query if it is a permanent table My full query is as follows: If t_pair is a permanent table, then it will work.

  Create a temporary table. Choose t_pair as separate pr_ns_a, pr_ew_a, pr_ns_b, pr_ew_b to t_score; Create a temporary table t_partner AS T_pair Choose a different pr_ns_a as the partner of the union Choose t_pair union as a partner separately Select the t_pair association Select different pr_ns_b t_pair by the partner as a partner of the t_pair order by the partner form Select different pr_ew_b in;  

You can not specify floating table more than once in a single query