Hi, I'm getting the following error message:
My SQL code query is:
Syntax error (missing operator) in query expression pr.productID = sp.product INNER JOIN productGroup pg ON pg.productGroupID = sp.productGroup'.
I really don't see what is wrong with this? The table names are correct, the field names are correct and in my opinion is there also nothing wrong with the query? Or do I miss something? If somebody see what is wrong please let me know
SELECT sp.subProduct, sp.latinName, sp.comment, sp.description, sp.healingProperties, sp.stones, sp.orderNumber, sp.inhoud, sp.price, pr.productName, pg.productGroupName FROM subProducts sp INNER JOIN products pr ON pr.productID = sp.product
INNER JOIN productGroup pg ON pg.productGroupID = sp.productGroup
Thank you in advance