>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"});
No need to write the join conditions twice in the query. Is this what you
want...
SELECT PictureName, ProdName, Description, SalesPrice
FROM Products
INNER JOIN ProdCategory USING(CategoryNr)
INNER JOIN ProductsPics USING(ProdNr)
WHERE ProdCategory.Category = $category;
ie only rows with matches across the 3 tables, scoped by $category?
PB
