{"id":3535,"date":"2025-10-05T00:00:00","date_gmt":"2025-10-04T22:00:00","guid":{"rendered":"https:\/\/tecnologia.euroinnova.com\/join\/"},"modified":"2025-10-14T11:28:52","modified_gmt":"2025-10-14T09:28:52","slug":"join","status":"publish","type":"post","link":"https:\/\/tecnologia.euroinnova.com\/en\/join","title":{"rendered":"JOIN"},"content":{"rendered":"

The JOIN statement is one of the most important and widely used concepts in SQL (Structured Query Language). Essentially, it is used to combine rows from two or more tables into one database<\/a>, based on a relationship between them. It is an essential tool for working with relational databases, where information is spread across multiple tables. Without the use of JOINs, extracting meaningful data spanning multiple tables would be much more complicated and less efficient.<\/p>\n

Types of JOIN<\/strong><\/h3>\n

There are several types of JOIN in SQL, each designed to handle different situations and query requirements. The main types of JOIN are described below:<\/p>\n

Inner join<\/strong><\/h4>\n

The Inner join<\/strong> This is the most common type of JOIN. It is used to return only those rows that have matching values in both tables involved. In other words, if the rows in one table do not have a match in the other table, they will not be included in the final result. This type of JOIN is very useful when you want to extract only the data that is relevant to both tables.<\/p>\n

Left join<\/strong><\/h4>\n

The left join<\/strong> (or left outer join<\/strong>) returns all rows from the left-hand table and the matching rows from the right-hand table. If there is no match, the rows from the right-hand table will appear as NULL in the result. This type of JOIN is useful when you wish to retrieve all rows from the main table, regardless of whether or not they have a match in the secondary table.<\/p>\n

Right join<\/strong><\/h4>\n

The right join<\/strong> (or right outer join<\/strong>) is similar to a left join, but with the tables reversed. It returns all rows from the table on the right and the matching rows from the table on the left. If there is no match, the rows from the table on the left will appear as NULL in the result. It is used when the right-hand table needs to be prioritised in the query.<\/p>\n

Examples of use<\/strong><\/h3>\n

To gain a better understanding of how these JOIN sequences work, let\u2019s look at some practical examples.<\/p>\n

Example of an inner join<\/strong><\/h4>\n

Let\u2019s suppose we have two tables: Customers<\/code> y Orders<\/code>. The table Customers<\/code> contains information about a shop\u2019s customers, and the table Orders<\/code> contains the orders placed by those customers.<\/p>\n

SELECT Customers.Name, Orders.OrderDate
\nFROM Customers
\nINNER JOIN Orders
\nON Customers.CustomerID = Orders.CustomerID;<\/p>\n

In this example, the INNER JOIN<\/code> returns a list of customer names along with the dates on which they placed orders, but only for those customers who have placed at least one order.<\/p>\n

Example of a left join<\/strong><\/h4>\n

Using the same tables Customers<\/code> y Orders<\/code>, we now want to obtain a list of all customers, including those who have not placed any orders.<\/p>\n

SELECT Customers.Name, Orders.OrderDate
\nFROM Customers
\nLEFT JOIN Orders
\nON Customers.CustomerID = Orders.CustomerID;<\/p>\n

This LEFT JOIN<\/code> will return a list of all customers, and if a customer has not placed an order, the column Order Date<\/code> will appear as NULL.<\/p>\n

Example of a right join<\/strong><\/h4>\n

Finally, let\u2019s see how a Right Join<\/code> using the same tables.<\/p>\n

SELECT Customers.Name, Orders.OrderDate
\nFROM Customers
\nRIGHT JOIN Orders
\nON Customers.CustomerID = Orders.CustomerID;
\nHere, the RIGHT JOIN<\/code> will return all records, including those that may not have a corresponding customer in the table Customers<\/code>. This could happen if, for example, a customer were deleted from the table Customers<\/code> but their orders are still in the database.<\/p>\n

Here are some related training courses that might interest you:<\/strong><\/p>\n