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.
FROM temp1 LEFT OUTER JOIN temp2
ON temp1.student_id = temp2.student_id
FROM temp2 LEFT OUTER JOIN temp1
ON temp2.student_id = temp1.student_id ;
I've tried parens, etc. Nothing helps. Thanks for any advice!