Answer:
Self Join
Explanation:
Required
The type of JOIN
Notice that the given query joins the customer table and the order table without using the keyword join.
SQL queries that join tables without using the keyword is referred to as self join.
Other types of join will indicate the "join type" in the query
