Tournament draws
SELECT tournid, tour.tourncode, Tournament, Sponsor, type,
scoring, target, bestof, max(round)
FROM gxsc_tournaments as tour
join gxsc_tournament_draw as draw
on draw.tourncode = tour.tourncode
and draw.year =
where tour.tourncode = 'WHC'
Invalid query: 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 'where tour.tourncode = 'WHC'' at line 7