Re: establishing a relationship

2003-06-07 Thread Becoming Digital
Digital www.becomingdigital.com - Original Message - From: <[EMAIL PROTECTED]> To: "Jeff Shapiro" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, 06 June, 2003 03:18 Subject: Re: establishing a relationship Yes, a "linking&q

Re: establishing a relationship

2003-06-06 Thread trogers
Yes, a "linking" table or a "map" table or a "join" table. "Linking" is what I see it called in books I have; yes I understand that. I hope to understand the advice for a third more thoroughly, too. I am doing this for practice so the theory of what I'm being taught is what I'm after and afai

Re: establishing a relationship

2003-06-05 Thread Jeff Shapiro
Ted, If in fact you only have a one-to-many relationship, you don't need the third table (what's also known as a join table in some circles). This type of table is only really needed if you are doing a many-to-many (people have 0 to infinity machines, and machines have 0 to infinity people).