SQL Select failed - please check syntax/table names for: select max(distinct gamedate) as 'daterequested' from game g join boxscore b where g.gameid = b.gameid and g.gamedate <= date(now())