How to use Joins?

How To Use Joins In SQL

Introduction:
In this article, you will learn what Joins are and how to use Join in SQL.
Join means, “Collection of two things”. By using SQL join, we collect the data in a single table from one or more tables.

Here, we have two tables-

Employee Table

Record Table

Now, we collect some records in both the tables.

Syntax

The Syntax of joining two tables is as follows.

Select column1, column2.... from table_name1, table name2 where [condition..];

Example

Step 1: We write our query for joining two tables.

Step 2: The output of this query is:

Summary:
Thus, we learned, Join combines the two object and its use.