How Would You Write A Left Join Statement To Return A Result Set Of M

1.	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 . SELECT movie.title, director.name FROM movie LEFT JOIN director ON movie.id = director.movie_id .

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 .

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