I think some backets are needed:


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

Pete