Preview:
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
​
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter