UNION JOIN

Explicit join operations

Using multiple tables in a query