Can you help me about this sql query about the INNER JOIN. The result return error

connection.query("SELECT caracavis.caracname FROM caracavis WHERE firstcaturl ='" + req.body[0].firstcatname + "' AND secondcaturl = '" + req.body[0].secondcatname + "' AND thirdcaturl = '" + req.body[0].thirdcatname + "' AND fourthcaturl = '" + req.body[0].fourthcatname + "' AND fifthcaturl = '" + req.body[0].fifthcatname + "' INNER JOIN critereproducts ON caracavis.caracname = critereproducts.nameurl", function (error, results, fields) {
				if (!!error) {
					console.log('erreur');
				} else {
					console.log(results);
					// res.json(results);
				};
			});

Can you help me about this sql query about the INNER JOIN. The result return error

connection.query("SELECT caracavis.caracname FROM caracavis WHERE firstcaturl ='" + req.body[0].firstcatname + "' AND secondcaturl = '" + req.body[0].secondcatname + "' AND thirdcaturl = '" + req.body[0].thirdcatname + "' AND fourthcaturl = '" + req.body[0].fourthcatname + "' AND fifthcaturl = '" + req.body[0].fifthcatname + "' INNER JOIN critereproducts ON caracavis.caracname = critereproducts.nameurl", function (error, results, fields) {
				if (!!error) {
					console.log('erreur');
				} else {
					console.log(results);
					// res.json(results);
				};
			});

• javascript
• mysql
• node.js

• What error do you get? – user184994 Commented Oct 25, 2017 at 19:33
• What is the error ? – Sagar Jajoriya Commented Oct 25, 2017 at 19:34

1 Answer 1

INNER JOIN es before WHERE.

SELECT caracavis.caracname
FROM caracavis 
INNER JOIN critereproducts 
ON caracavis.caracname = critereproducts.nameurl
WHERE ...