Peter, the brackets works, thanks a lot.

Eric, why is there a need to put the square brakets [] in your
previous reply? I am just curious what will these [] do? Please advise,
thanks.

Once again thanks all of you who have share your professional tips.

>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