SEMI-JOINS in SQL

Continuing our series about lesser-know types of SQL joins, let's look at the SEMI-JOIN today. What does it do? Well, we filter the entries in the left table to only the keys found in the right table, but unlike an INNER JOIN, we:- we only get the co...