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
- Re: Problem selecting from 3 tables B. Fongo
- Re: Problem selecting from 3 tables Peter Brawley
- List of fields Scott Haneda
- AW: Problem selecting from 3 tables B. Fongo
