OK, I've made further progress by changing GROUP BY ProductTB.ProductID, MasterTB.MasterID to GROUP BY MasterTB.MasterID.
However ProductTB.Supplier is showing the incorrect Supplier. Why is this ? Thanks Neil On Mon, Dec 22, 2008 at 11:45 AM, Tompkins Neil < neil.tompk...@googlemail.com> wrote: > Hi, > > If anyone could point me in the right direction, I'd be most grateful. > > Thanks ! > > Neil > > On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil < > neil.tompk...@googlemail.com> wrote: > >> Hi >> >> I'm having trouble trying to figure this out. Any help/example would be >> grateful. >> >> Thanks >> Neil >> >> On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz <ba...@xaprb.com>wrote: >> >>> On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil >>> <neil.tompk...@googlemail.com> wrote: >>> >>> > of products for all suppliers for a particular product. However I want >>> to >>> > be able to show the lowest price product from just the lowest priced >>> > supplier. >>> >>> http://jan.kneschke.de/projects/mysql/groupwise-max >>> >>> http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ >>> >>> -- >>> Baron Schwartz, Director of Consulting, Percona Inc. >>> Our Blog: http://www.mysqlperformanceblog.com/ >>> Our Services: http://www.percona.com/services.html >>> >> >> >