erid, name
> 1 Fred
> 2 Jack
> 3 Jill
>
> "movies"
> movieid, title
> 1 Fear and loathing
> 2 Monkey Town
> 3 PHP: The film
> 4 PHP: The sequel
>
> "viewings"
> viewingid, memberid, movieid
> 1 2 2
> 2 1 4
> 3 1 1
> 4 3 4
>
I am having a problem designing a query on a mysql 3.23 database.
I have 2 tables - "member" and "movie".
The "member" table stores the people details, the "movie" table records the
movies they have seen (each record is one movie).
MEMBER
memberid int not null auto_increment primary key,
membern
