select with left join - Cacher Snippet

4/25/2020 - 2:39 AM

select with left join

select-left-join.sql

SELECT 
`movies`.`path`, `movies`.`filename`,`movies`.`format_long`,
`video`.`resolution_code`
FROM
 `movies`
 LEFT JOIN `video` ON `movies`.`id` = `video`.`movie_id`
ORDER BY `movies`.`filename`