Join

A relational database consists of multiple related tables linking together using common columns which are known as foreign key columns. Because of this, data in each table is incomplete from the business perspective.

For example, in the sample database, we have the orders and orderdetails tables that are linked using the orderNumber column:

MySQL Transaction: orders & orderDetails Tables

To get complete orders’ information, you need to query data from both orders and orderdetails tables.