> -----Original Message----- > From: Joshua Olson [mailto:joshua at waetech.com] > Sent: Tuesday, October 15, 2002 4:18 PM > To: thelist at lists.evolt.org > Subject: Re: [thelist] SQL: COUNTing and SUMming and whatnot > > > ----- Original Message ----- > From: "Chris W. Parker" <cparker at swatgear.com> > Sent: Tuesday, October 15, 2002 5:42 PM > > > > let me list the tables and their fields. > > > > productTracking: > > * id (autonumber) > > * ptProduct (number, comes from id.PossibleProducts) > > * ptReferralSource (number, comes from id.PossibleAdverts) > > > > PossibleProducts: > > * id (autonumber) > > * ppName (text, name of product) > > > > PossibleAdverts: > > * id (autonumber) > > * paName (text, name of product) > > So far, the names of the tables and the descriptions of what > they do are > somewhat confusing, since the three tables you said you have are: > > 1. stores the individual occurrences > 2. stores the possible ads (productA, productB, productC, etc.) > 3. stores the possible sources (magazineA, magazineB, magazineC, etc.) > > I'm not sure how those three tables match with the schema you > presented > above. i just used the wrong words when i listed them (i.e. 1,2,3). #1 is the productTracking table, #2 is the PossibleProducts table, and #3 is the PossibleAdverts table. does that make sense, or am i still unclear? chris.