innerJoin query show error
- by Chithri Ajay
just i print the two table data so i am using inner join
SELECT sd.GameName
FROM LottoryTickets AS sd
JOIN group AS p
ON sd.Group = p.groupname
WHERE p.groupname = 11
now i get #1064 - 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 'group AS p ON sd.Group = p.groupname WHERE p.groupname = 11 LIMIT 0, 30' at line 3
this response please guide me
thanks for advance.