sql - mysql query two tables, UNION and where clause - Stack Overflow
There are two problems with your SQL: (THis is not the question, but should be considered) by using WHERE over the UNION instead of the tables, you create a performance nightmare: MySQL will create a temporary table containing the UNION, then query it ove...