LEFT OUTER JOIN
http://www.seshop.com/se/edu/shikaku/omo/miti/silver_miti26.asp?educat=silver2
完全に忘れてる。。。
一例
select movie.id,movie.title,movie.price,publisher.name from movie left outer join publisher on movie.id = publisher.id
movie(全件) ← publisher