[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Distinct Query Problem
From:       "Tompkins Neil" <neil.tompkins () googlemail ! com>
Date:       2008-12-23 18:25:51
Message-ID: accac14e0812231025m104ef38byc76f8ca882c9520e () mail ! gmail ! com
[Download RAW message or body]


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.Raghani@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.tompkins@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.tompkins@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 <baron@xaprb.com>
> wrote:
> >
> >> On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
> >> <neil.tompkins@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
> >>
> >
> >
>


[prev in list] [next in list] [prev in thread] [next in thread]