Inner join (3)

The ability to combine multiple joins in a single query is a powerful feature of SQL, e.g: