2t7mXEQf

1SELECT Id, Name, Score FROM MAIN
2
3UNION
4
5SELECT d.New_Id AS Id, c.Name, c.Score FROM MAIN c
6RIGHT JOIN SUB d
7
8ON c.Id = d.Id
9	
10CREATE TABLE IF NOT EXISTS TEST (
11
12SELECT Id, Name, Score FROM MAIN
13
14UNION
15
16SELECT d.New_Id AS Id, c.Name, c.Score FROM MAIN c
17RIGHT JOIN SUB d
18
19ON c.Id = d.Id );
20	
21ERROR 1064 (42000) at line 5: 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 'UNION