i dont see an error in your syntax, do you get the syntax error when testing the recordset? or when viewing the page in the browser?
have tried running thee query directly in PHPMyAdmin or another MySQL GUI Tool? i find it helpful to use a GUI tool for getting the syntax correct before creating the recordset in DW.
see this page for details on the syntax for a join query: