[snip]
But here's where I'm stuck: for each film, I need to pull the movie info
in
'movies', plus any related data from other tables, like this:
The Lord of the Rings | Peter Jackson | 3 comments
Episode II | George Lucas | 0 comments
Indiana Jones | Steven Spielberg | 15 comments
I seem to run into problems when I try to join info from all of these
related tables. If there's a match, great. But, if not (like a movie
with no
comments), the movie is excluded from the result set.
I've tried all sorts of SQL queries to make this work, but nothing seems
to
do the trick.
[/snip]
You can probably succeed with OUTER JOINS --
SELECT foo
FROM movie LEFT OUTER JOIN director
ON movie.director = director.name
LEFT OUTER JOIN
ON movie.id = comments.id
ETC
HTH!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
