Re: how about fixing some code like this?

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=199608#199608
----------------------------------------------------------------

Sound like a fine idea to me.

One question that has bugged me over the past couple of days, maybe you can answer:

[quote="cstsai"][code]
select
	p.products_id,
	p.products_image,
	max(o.date_purchased) max_date_purchased
from
....
group by
	p.products_id
....
[/code]

[/quote]

My understanding is that this is in fact invalid SQL code?
How is your database going to know which one of the p.products_image entries it is going to show, since you are grouping by p.products_id?
How does MySQL deal with, cases like this?


Cheers,
Rob