Results 1 to 5 of 5
Oct 6, 2013, 03:47 #1
- Join Date
- Sep 2013
- 0 Post(s)
- 0 Thread(s)
Full outer join error - example for SimplySQL
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:
SELECT a,b FROM A FULL OUTER JOIN B ON a=b ;
"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.