MySQL INNER JOIN

Print Thread

MySQL INNER JOIN #31115 25 Jan 16 10:57 AM
Joined: Jun 2001 Posts: 3,406 Porto-Portugal/Rio de Janeiro-... J Jorge Tavares - UmZero OP Member
OP Jorge Tavares - UmZero Member J Joined: Jun 2001 Posts: 3,406 Porto-Portugal/Rio de Janeiro-...	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) Jorge Tavares UmZero - SoftwareHouse Brasil/Portugal

Re: MySQL INNER JOIN #31116 25 Jan 16 11:04 AM
Joined: Jun 2001 Posts: 3,406 Porto-Portugal/Rio de Janeiro-... J Jorge Tavares - UmZero OP Member
OP Jorge Tavares - UmZero Member J Joined: Jun 2001 Posts: 3,406 Porto-Portugal/Rio de Janeiro-...	Ok, it seems that the WHERE clause must be at the end :p Jorge Tavares UmZero - SoftwareHouse Brasil/Portugal

Re: MySQL INNER JOIN #31117 26 Jan 16 10:44 AM
Joined: Nov 2006 Posts: 2,223 Northwest Arkansas S Stephen Funkhouser Member
Stephen Funkhouser Member S Joined: Nov 2006 Posts: 2,223 Northwest Arkansas	Glad you figured it out, and you answered yourself so quickly! Stephen Funkhouser Diversified Data Solutions