In the Sitepoint book 'SimplySQL' we are asked to create two tables consisting of nothing but 1 column of numbers and are then asked to run the query:
A FULL OUTER JOIN B
This is causing the error:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUTER JOIN B
ON a=b' at line 4"
Changing the "full" outer join to "left" brings a result. Please can someone explain to me what I'm missing, I've tried reading the MySQL documentation and googling for an explanation but I'm at a loss.
P.S. First time in a forum so please give me any necessary feedback regarding etiquette, etc.