Can't execute query

SELECT tblClubs.clubname,tblClubSites.sitecode 
FROM tblClubs 
INNER JOIN tblClubSites on tblClubs.clubid = tblClubSites.clubid
WHERE tblClubs.clubid =

MySQL Error: 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 '' at line 4

This script cannot continue, terminating.