I like to think of full outer joins as the most conservative join and the inner join as the least conservative join (quite literally "conserving" rows).