SQL Basics
Menu
Querying Data
Menu
Filtering Data
Menu
Joining Tables
Menu
SQL Functions
Menu
Modifying Data
Menu
Defining Data
Menu
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.
.
Baraa Khatib Salkini
I am senior IT solution architect with 10 years of experience working in top projects in top companies in Germany. I will share my experience by creating tutorials about data, Data Analytics, Data Engineering, Data Modelling, Data Visualization, Data Mining and A.I.
All Posts