How would you write a LEFT JOIN statement to return a result set of movie.title's and director.name's?

Submitted by: Administrator
SELECT
movie.title,
director.name
FROM movie LEFT JOIN director ON movie.id = director.movie_id
Submitted by: Administrator

Read Online ColdFusion Job Interview Questions And Answers