Thanks Matthew,
I can see the advantages of the table structure you recommend, but what
would be the select statement to find people who have seen both "Fear and
loathing" AND "Monkey Town"?
Matthew Crouch <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You n
You need an associating table; members and movies are in a many-to-many
relationship here.
The associating table represents the act of viewing-a-movie, and describe who
and what are involved
comme ca:
"members"
memberid, name
1 Fred
2 Jack
3 Jill
"movies"
movieid, title
1 Fear and loathing
2 Mo