Node js sql query inner join

Question

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);
				};
			});

What error do you get?

user184994
– user184994

2017-10-25 19:33:21 +00:00
Commented Oct 25, 2017 at 19:33 — user184994
– user184994, Commented Oct 25, 2017 at 19:33
What is the error ?

Sagar Jajoriya
– Sagar Jajoriya

2017-10-25 19:34:15 +00:00
Commented Oct 25, 2017 at 19:34 — Sagar Jajoriya
– Sagar Jajoriya, Commented Oct 25, 2017 at 19:34

Jacob Barnes · Accepted Answer · 2017-10-25 19:34:37Z

4

INNER JOIN comes before WHERE.

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

answered Oct 25, 2017 at 19:34

Jacob Barnes

1,5801 gold badge13 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jean Over a year ago

It works ! I can't accept now, should wait 7min. thanks

Jacob Barnes Over a year ago

You're welcome. Off on a tangent, but you can do join syntax in the WHERE clause, but you wouldn't use JOIN statements. You'd just list the tables in the FROM clause, then in the WHERE clause you'd enforce the relationship, which is very similar to what you attempted but a mix of the two. Recommended approach is always use ANSI Join syntax, e.g. INNER JOIN, over the old style.

Collectives™ on Stack Overflow

Node js sql query inner join

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related