ACCESS and multiple INNER JOIN statements 1

[marcasii]

Hi, I am trying to do a SELECT that has two INNER Join tables in it but it comes back with a Syntax error. I can do the same statement with MS SQL and it works but is the Access syntax different? The SELECT statement is:

SELECT * FROM PROD_SUBS
INNER JOIN PRODUCTS ON products.productID = PROD_SUBS.productID
INNER JOIN SUBCATEGORIES on subcategories.subcategoryID = PROD_SUBS.subCategoryID
ORDER BY PROD_SUBS.subCategoryName

Does anyone know the correct syntax? Or can you not join three tables with Access?

 

[BNPMike]

Don't post the same thing in multiple forums. That's the same as spamming.

 

[marcasii]

How is that spamming? Different people read different forums, it just increases the chance of someone responding who can actually give a worthwile response.

 

[JeremyNYC]

It's rude, because someone could answer it in one forum and then other people could spend their time answering it in another forum. It's very frustrating for people who are out there helping folks.

You might want to take a look at the thread I link to in my sig file. It sounds like you're not a newbie programmer, so you'll already understand some of the stuff in there about community. But if you do happen to be new to forums like this, it will definitely help you make friends around here.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.