Pulling out from multiple tables...?!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Pulling out from multiple tables...?!

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

try "group by uploads.product_name" instead.
Post Reply