MySQL Forums
Forum List  »  Newbie

Re: Help with a query please
Posted by: sonreir
Date: May 19, 2005 09:01AM

How can I rewrite my query to get the desired results then?

If I include supplier.name in my group by clause, I'm no longer getting a single lowest price for each product (and the supplier that has that lowest price), I'm just getting the lowest price for each product from each supplier.

Options: ReplyQuote


Subject
Written By
Posted
May 17, 2005 02:27AM
May 18, 2005 02:23AM
Re: Help with a query please
May 19, 2005 09:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.