SQL syntax error Multiple inner join

Question

SELECT *
FROM tproducts
INNER JOIN torder ON tproducts.Product_ID=torder.Product_ID
INNER JOIN tcustomer ON torder.Customer_ID=tcustomer.Customer_ID

Can anyone see what is wrong with this as VB.net says that there is a missing operator and i cant spot it?

What is the error you are getting? What database are you using? — Gordon Linoff
– Gordon Linoff, Commented Dec 2, 2014 at 16:29
VB.net -- are you using MS Access? It has unique and finicky requirements for enclosing joins in (). Your SQL looks like it would be valid in any other RDBMS as long as the columns exist. — Michael Berkowski
– Michael Berkowski, Commented Dec 2, 2014 at 16:30
look like fine till now, include what the error you getting and include vb.net code also where are you calling this? — HaveNoDisplayName
– HaveNoDisplayName, Commented Dec 2, 2014 at 16:30

Gordon Linoff · Accepted Answer · 2014-12-02 16:33:07Z

4

In MS Access, you need to use parentheses for multiple joins:

SELECT *
FROM (tproducts INNER JOIN
      torder
      ON tproducts.Product_ID = torder.Product_ID
     ) INNER JOIN
     tcustomer
     ON torder.Customer_ID = tcustomer.Customer_ID;

No other database requires this, and using parentheses like this looks awkward for any other database.

answered Dec 2, 2014 at 16:33

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

SQL syntax error Multiple inner join

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related