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,LastName,FirstName,etc.
movies: MovieID,Title,etc.
casts: ActorID,MovieID,CharacterLastName,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