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
​