sql - MS Access Query Syntax Error in FROM -

For an assignment, I ordered the customer's last name, order date, product ID, product cloth, quantity, and Unit Price

This table contains.

Sis ( CID , this is a table and the user should be INNERJOIN, even though it can be used.

Last, first, call )

( OrdID , OrdDate, SHIPDATE CID)
Manu ( ManuID , name, phone, city)
Prods ( prid < / Strong>, ManuID, category)
ProdFabric ( prid , textile , value)
order line ( OrdId , PID , Fabric , Volume)

Bold means it is part of the primary key or the overall key.

The query I entered, but I keep getting a syntax error on it and it keeps the command highlighted for some reason (after Cus INNERJOIN).

  Select Last, OrdDate, ProdskPrID, fabric, quantity, price Cus INNERJOIN order INNERJOIN Orderline INNERJOIN on OrderLine.PrID = ProdFabric.PrID on ProdFabric and Orderline.Fabric = ProdFrabric.Fabric On and Cus.CID = Orders.CID and Orders.OrdID = Orderlin e.OrdID;  

What is the reason for this and how do I solve it?

Apiaaim require dissemination such as brackets for Lisp to support multiple join MS Access .

• Edit your MS Access query in another editor that supports Perron-matching and syntax-highlighting, for example. . Notepad ++
• table using the nickname with

brackets to keep your questions short and more manageable, your query would look something like this :.

  c.Last, o.OrdDate, pf.PrID, pf.Fabric, ol.Qty, ones pf.Price ((Cus c INNER JOIN command c.CID o = O.CID) Join Inner Order Line ON ON ORDID = ol.OrdID) INNER ProdFabric PF on ol.PrID = pf.PrID;