Hi all,
I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer. In the tableAds I have a column ProductsID so I know what Product is advertised. Now I want to find all the adsvertisments of products which are made by a specific manufacturer. I'm trying a query like: SELECT * FROM tableAds LEFT JOIN tableProducts ON (tableProducts.productsID=tableAds.productsID) LEFT JOIN tableManufacturers ON (tableManufacturers.manufacturersID=tableProducts.manufacturersID) WHERE manufacturersID=12 However this query returns all advertisments in the tableAds and not the Ads wirth manufacturer number 12 involved. Anybody knows how to improve this query? Any help would be much appreciated. thx in advance. Wilbert Enserink ------------------------- Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] ------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
