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
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
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
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:
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
ContentTB - Contains description of product, and location of data files
PriceTB -
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