Re: Many:Many Relation Between Database Tables

2007-07-05 Thread David T. Ashley
On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote: > > a)I'm assuming that under MySQL I have to create a third table that maps > between them? (Let's call it "users2priveleges".) > > b)I'm assuming that there is nothing special I need to do to get, for > example, all the priveleges with a u

Re: Many:Many Relation Between Database Tables

2007-07-05 Thread Dan Buettner
David, you've hit the nail on the head. Dan On 7/5/07, David T. Ashley <[EMAIL PROTECTED]> wrote: I'm an old Microsoft Access user, so I just need to double-check on this with MySQL: I want to relate two tables (let's call them "users" and "priveleges") in a many:many way. That is, each use