What database are you running in the back end? If you are going against an Access (Jet) database then you may need to close your SQL statements with a ; like so:

SELECT * FROM products INNER JOIN...