seems to me that some lines are reverted:
SELECT StockItems.Code,StockItems.Description,StockItems.Dpt,Departments.Description,StockItemsPrc.Price
FROM StockItems
INNER JOIN StockItemsPrc
ON StockItems.Code = StockItemsPrc.Code
INNER JOIN Departments
ON StockItems.Dpt = Departments.Code
>Error: FROM clause
>
>SELECT StockItems.Code,StockItems.Description,StockItems.Dpt,Departments.Description,StockItemsPrc.Price FROM StockItems
>INNER JOIN StockItemsPrc
>INNER JOIN Departments
>ON StockItems.Code = StockItemsPrc.Code
>ON StockItems.Dpt = Departments.Code
>
>Notes:
>Tables: StockItems, StockItemsPrc, Departments
>
>Where StockItems is the main table, and like to retrieve Price from
>StockItemsPrc table(using item code key) and department decription from
>Departments table(using department code key).
>
>How could I achieve the wanted result using the INNER JOIN operation?
>Please help, thanks.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com