ah that's what I'm doing. I was doing it wrong, but went to a meeting and the wrong information displayed. I was aligning primary keys, you are right, and should've been doing a foreign key to a primary key. Thanks Deanna!
>It's no the primary keys that need to be =. What you need is to have a >foreign key in the table that holds the email. So, for example, you'd >have: >empower_local_case_studies >studyid (PK) >name >etc > >empower_registration >registrationid (PK) >studyid (FK) >etc. > >Then, you'd join: >WHERE erc.studyid = er.studyid > >Does that make sense? > >On 6/7/05, daniel kessler <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208844 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
