On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote: > Basically each product is listed in the master table, and can have a number > of suppliers linked to it (ProductTB). The query above will show me a list > 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.
Search the manual for "group-wise maximum". Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org