Sometimes problems solved with semi-joins can also be solved using an inner join.