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,087
  • 10
  • 49
  • 72
  • 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
  • 111,943
  • 16
  • 178
  • 202