AW: Problem selecting from 3 tables

2004-03-13 Thread B. Fongo
etc. - -Ursprüngliche Nachricht- Von: Peter Brawley [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 13. März 2004 06:40 An: B. Fongo; [EMAIL PROTECTED] Mysql. Com Betreff: Re: Problem selecting from 3 tables &

Re: Problem selecting from 3 tables

2004-03-12 Thread Peter Brawley
>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) WHE

Problem selecting from 3 tables

2004-03-12 Thread 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