ColdFusion Question: Download ColdFusion PDF

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

SELECT
movie.title,
director.name
FROM movie LEFT JOIN director ON movie.id = director.movie_id

Previous Question	Next Question
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query?	How do you call a module named “testmod.cfm” with the parameters param1=”yes” and param2=5?