CROSS JOIN

The CROSS JOIN returns all records where there is a match in either the left or right table records. If we take the order and customer table example, it will return five rows with customer and order details:

SELECT order.order_id, customer.name FROM order OUTER_JOIN customer ON order.customer_id = customer.customer_id;