sql question
From: Adam Shaw <shaw_at_contrapunctus.net>
Date: 10 Oct 2003 12:43:34 -0700
Message-ID: <961454d1.0310101143.4e56ec41_at_posting.google.com>
Date: 10 Oct 2003 12:43:34 -0700
Message-ID: <961454d1.0310101143.4e56ec41_at_posting.google.com>
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 Received on Fri Oct 10 2003 - 21:43:34 CEST