Everywhere I see Inner Joins, right joins, left joins etc but what kind of join is just the regular one. e.g.
SELECT titel FROM films AS f JOIN reviews AS r ON f.id = r.film_id
An inner join is considered a "regular" join.