DATA with BARAA

SQL Alias

In this tutorial, you will learn how to join two tables to get combined data.

Up to this point, we’ve only been querying only one table at a time. But in real-life situations, you often need to query two or more tables at a time. If you want to get something meaningful out of data.

The process of linking tables is called joining. In order to join tables, you need to specify the common columns that are available in both tables.

Types of Joins

When you join tables together, the type of join that you specify in your query affects the rows that appear in the result set. SQL provides the following type of joins:

Only matching rows

All rows from left Table

All rows from right Table

All rows from both Tables

In the next tutorials, we will learn more about each type of join with examples.

.
Share it !