ColdFusion Question:
Download Questions PDF

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

Answer:

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

Download ColdFusion Interview Questions And Answers PDF

Previous QuestionNext 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?