Hi Sonal, What information do you require ? Basically in the MasterTB we have productID and name, description. In the LookupTB we have the productID from the MasterTB, the productID from ProductTB and a char field for preferred supplier Yes/No. In the ProductTB we have a list of products from each supplier. This is link using the LookupTB.
Let me know what other information you require. Thanks Neil On Tue, Dec 23, 2008 at 4:19 AM, Raghani, Sonal (IE10) < sonal.ragh...@honeywell.com> wrote: > Hi, > > The problem statement needs to be elaborated. Please give the exact > columns interms of wat is suppliers which table is it coming from > etc..... > > -----Original Message----- > From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] > Sent: Monday, December 22, 2008 5:16 PM > To: Baron Schwartz; [MySQL] > Subject: Re: Distinct Query Problem > > 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 > >> > > > > >
