Page 1 of 1

Pulling out from multiple tables...?!

Posted: Tue Jan 04, 2005 4:37 pm
by Steveo31
I'm having some serious probs with thse kinda queries...

Code: Select all

SELECT inventory.store_name, inventory.product_name, inventory.upload_date, uploads.thumb_path, SUM(products.search_hits) as search_hits, SUM(products.hits) as hits FROM inventory, uploads, products WHERE inventory.store_name = 'Steve''s Store' AND products.product_name = uploads.product_name GROUP BY products.product_name ORDER BY inventory.upload_date DESC
Brings up

Code: Select all

Steve's Store  	Car  	2005-01-04 14:11:34  	members/Steveo31/toaster_thumb.jpg  	0  	9
Steve's Store 	Car 	2005-01-04 14:11:34 	members/Steveo31/modelt_thumb.jpg 	0 	9
Steve's Store 	Car 	2005-01-04 14:11:34 	members/Steveo31/tools_thumb.jpg 	0 	33
Whereas it should be

Code: Select all

Steve's Store  	Toaster  	2005-01-04 14:11:34  	members/Steveo31/toaster_thumb.jpg  	0  	9
Steve's Store 	Car 	2005-01-04 14:11:34 	members/Steveo31/modelt_thumb.jpg 	0 	9
Steve's Store 	Tools 	2005-01-04 14:11:34 	members/Steveo31/tools_thumb.jpg 	0 	33
Is there something I should know about these types of queries?

Posted: Tue Jan 04, 2005 4:44 pm
by feyd
try "group by uploads.product_name" instead.