> -----Original Message----- > From: rudy [mailto:r937 at interlog.com] > Sent: Tuesday, October 22, 2002 10:43 AM > To: thelist at lists.evolt.org > Subject: Re: [thelist] SQL: looking for resources, have one question > > > > am i being clear? > > about what you're trying to do, yes > > about how the three tables relate to each other, no ;o) > > which columns are foreign keys, i.e. which can be joined on? ooohhhh... you mean, that's important information? well hopefully this will answer your question. (so we can both get on with our lives. ;) productTracking * id PK * ptProduct (reference to PossibleProducts.id, so I guess this makes it a FK?) * ptReferralSource (reference to PossibleAdverts.id, FK?) * ptComments (comments made by customer) * ptUsername (sales person that made entry) * ptDate (date/time entry was recorded) PossibleProducts * id PK * ppName (referenced by productTracking.ptProduct) PossibleAdverts * id PK * paName (referenced by productTracking.ptReferralSource) i put FK? because i wasn't sure if that's what a Foreign Key is or not. hth, chris.