Problem selecting from 3 tables

[B. Fongo]

I'm having trouble with sql statement to select from 3 tables.
The first column is in ProductsPics and the rest in Products.
 
 
(qq{SELECT PictureName, ProdName, Description, SalesPrice FROM Products
INNER JOIN
            ProdCategory USING(CategoryNr) INNER JOIN ProductsPics
USING(ProdNr) WHERE Products.CategoryNr 
            = ProdCategory.CategoryNr AND Products.ProdNr =
ProductsPics.ProdNr 
            AND ProdCategory.Category = "$category"});
 
 
Thanks for any help
 
Babs