INNER JOIN Error
SELECT tournaments.CategoryID, tournaments.TournamentID, tournaments.TournamentDate, tournaments.TournamentDeadline, tournaments.TournamentName, tournaments.TournamentDisplayStart, tournaments.TournamentDisplayEnd, tournaments.TournamentDisplay
FROM tournaments INNER JOIN tournamentcategories ON tournamentcategories.CategoryID = tournaments.CategoryID
I'm trying to JOIN tournamentcategories.CategoryID to tournaments.Category, after many attempts I'm now getting an syntax error, line 34