Find Out How To Use Filtering In SQL JOINs - Vertabelo Academy Online Interactive Course

PHOTO EMBED

Wed Nov 30 2022 03:00:33 GMT+0000 (UTC)

Saved by @vnmshenoy

SELECT
 b.title,
 b.publishing_house,
 a.title,
 a.type 
FROM book b
LEFT OUTER JOIN adaptation a
ON b.id=a.book_id
WHERE type='movie'
or type IS NULL
​
content_copyCOPY

good to read the link

https://learnsql.com/course/joins/joins/filtering-with-left-join-and-right-join/filtering-with-joins