Posted 27 July 2008 - 10:08 PM
Well, sorry to bother you, but I have yet another MYSQL question.
when I try executing this command:
mysql> SELECT PLAYERNO FROM PENALTIES
-> SELECT PLAYERNO FROM TEAMS;
I end up with this eror:
ERROR 1064 (42000): 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 'SELECT PLAYERNO FROM TEAMS' at line 3
I have no problems with either command on its own, (SELECT PLAYERNO FROM TEAMS; SELECT PLAYERNO FROM PENALTIES;) but when put with INTERSECT I get an error.
I get no errors when I try the same command using UNION.
What on earth is the problem?
I'd greatly appreciate your help.