outer join in mysql on tables created in subqueries

266 Views Asked by At

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?

1

There are 1 best solutions below

0
On BEST ANSWER

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