UNION query doesn't work...?
I discovered to my chagrin that MySQL does not do FULL OUTER JOINs. (Does SQLite?)
At any rate, after much researching, I have come to believe that the closest I will come to the FULL OUTER JOIN is the UNION query. In the code below, each of the queries works alone, but when I try to join them with the UNION clause, I recieve an error saying that "can't reopen temp2".
Bear in mind that these are temporary tables.
|All times are GMT. The time now is 08:53 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0