Hello SQL gurus,

I'm trying to execute the following query over an MySQL database in an online store and, everytime, I'm receiving a syntax error message; probably it is a basic mistake on my side, can anyone help me figure out where it is?
Thanks in advance

(I've pasted the command exactly the way I'm using it, instead of making it more readable)

SELECT p.product_sku, c.customfield_params FROM rsnlb_virtuemart_products AS p WHERE p.product_parent_id="0" INNER JOIN rsnlb_virtuemart_product_customfields AS c ON (p.virtuemart_product_id=c.virtuemart_product_id)

Ok, it seems that the WHERE clause must be at the end :p

Glad you figured it out, and you answered yourself so quickly!