[snip]
Thanks, Jay and Andy! OUTER JOINS work great for part of my query.
But how would you modify this query to support multiple directors?
(That's
why I've got a movie_director table.)
Movie Name | Director A, Director B, etc. | 35 comments
Best,
Patrick
> SELECT foo
> FROM movie LEFT OUTER JOIN director
> ON movie.director = director.name
> LEFT OUTER JOIN
> ON movie.id = comments.id
[/snip]
Sounds as if your table is not normalized for that kind of query. If
there are multiple directors id'd by multiple movies you could left
outer join the movie.id with the director.id
Make sense?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
