都使用过哪些join?

初学者说这2个
inner join
(left/right) outer join

再牛逼点补充下下面2个
cross join
self-join