DATA with BARAA

DATA with BARAA

fun with data

SQL Basics

Querying Data

Filtering Data

Joining Tables

SQL Functions

Modifying Data

Defining Data

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 !
Ask Questions
Baraa Khatib Salkini

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