I need some help identify the error this query has:

The error is: Syntax error (missing operator) in query expression

SELECT six.Location as Loc6, six.WorkshopName as Nam6, six.Overall as Overall6,
seven.Location as Loc7, seven.WorkshopName as Name7, seven.Overall as Overall7
FROM locations loc
RIGHT JOIN main six ON (loc.locid = six.locid AND six.Overall =6)
RIGHT JOIN main seven ON (loc.locid = seven.locid AND seven.Overall =7);