0

This question shows how to do outer join in mysql, but can I do a full outer join between sub-queries as tables without having to re-execute the sub-queries for each half of the union?

Community
  • 1
  • 1
tbischel
  • 6,337
  • 11
  • 51
  • 73
  • Can you show those queries, the table structure, and a textual description of the desired result. There may be another solution. – GolezTrol Oct 28 '11 at 18:29
  • I did find another way, but I was curious if there was a way to select into tables which could be reused for that particular type of join. – tbischel Nov 01 '11 at 17:18

1 Answers1

0

I'm afraid you can't, but the query optimizer may be smart enough to keep the performance hit to a minimum.

GolezTrol
  • 114,394
  • 18
  • 182
  • 210