--- Torsten Roehr <[EMAIL PROTECTED]> wrote:
> "Rachel Rodriguez" <[EMAIL PROTECTED]>
> wrote in message
>
news:[EMAIL PROTECTED]
> > Hi!
> >
> > I have a one-to-many relationship between two
> tables
> > (table1 and table3) with a "linking" table between
> > them (table2):
> >
> > table1: table2
> > +---+--------+ +---+--------+
> > |id | f_name | |id | emailID|
> > +---+--------+ +---+--------+
> > | 1 | bill | | 1 | 1 |
> > | 2 | john | | 1 | 4 |
> > | 3 | diana | | 1 | 3 |
> > | 4 | victor | | 2 | 2 |
> > | 5 | renata | | 4 | 5 |
> > +---+--------+ +---+--------+
> >
> > table3
> > +--------+-----------------+
> > |emailID | email |
> > +--------+-----------------+
> > | 1 | [EMAIL PROTECTED]|
> > | 2 | [EMAIL PROTECTED] |
> > | 3 | [EMAIL PROTECTED] |
> > | 4 | [EMAIL PROTECTED] |
> > | 5 | [EMAIL PROTECTED] |
> > +--------+-----------------+
> >
>
> Hi Rachel,
>
> if you know that you will always have a one to many
> relationship and never a
> many to many relationship you don't need table2 at
> all. Just add column 'id'
> to table three as the foreign key. This should make
> your life easier.
>
> Regards, Torsten
>
>
> > I would like to write a query that matches
> table1.id
> > with records
> > from table3.emailID via the linking table (table2)
> and
> > then
> > assign each match to a variable.
> >
Thanks Torsten! The database design tip is useful,
but I'm still stuck with the variable assignment
problem from my original post.
Thanks,
Rachel
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�
http://photos.yahoo.com/ph/print_splash
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
