Here's a SQL question a friend asked me recently...I came up with a
solution, but I'm not sure it's the ideal one, so let me know what
y'all think...
His database has a table of actors in it, a table of movies, and an
intermediate table ("casts") containing the keys from both. The tables
are roughly like this:
actors: ActorID,LastNam e,FirstName,etc .
movies: MovieID,Title,e tc.
casts: ActorID,MovieID ,CharacterLastN ame,etc.
He wanted to know, how can I select all movies with Robert DeNiro and
Joe Pesci in it?
How best to do it?
-ams