[thelist] SQL: COUNTing and SUMming and whatnot

[Chris W. Parker]

> -----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.