ColdFusion Interview Question:

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