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
movie.title,
director.name
FROM movie LEFT JOIN director ON movie.id = director.movie_id
Download ColdFusion Interview Questions And Answers
PDF