As the name shows, JOIN means to combine something. In case of SQL, JOIN means “to combine two or more tables”.

The SQL JOIN clause takes records from two or more tables in a database and combines it together.

ANSI standard SQL defines five types of JOIN :

  1. inner join,
  2. left outer join,
  3. right outer join,
  4. full outer join, and
  5. cross join.

In the process of joining, rows of both tables are combined in a single table.

Why SQL JOIN is used?

If you want to access more than one table through a select statement.

If you want to combine two or more table then SQL JOIN statement is used .it combines rows of that tables in one table and one can retrieve the information by a SELECT statement.

The joining of two or more tables is based on common field between them.

SQL INNER JOIN also known as simple join is the most common type of join.

How to use SQL join or SQL Inner Join?

Let an example to deploy SQL JOIN process:

1.Staff table

IDStaff_NAMEStaff_AGESTAFF_ADDRESSMonthley_Package
1ARYAN22MUMBAI18000
2SUSHIL32DELHI20000
3MONTY25MOHALI22000
4AMIT20ALLAHABAD12000

2.Payment table

Payment_IDDATEStaff_IDAMOUNT
10130/12/200913000.00
10222/02/201032500.00
10323/02/201043500.00

So if you follow this JOIN statement to join these two tables ?

SELECT Staff_ID, Staff_NAME, Staff_AGE, AMOUNT   

   FROM STAFF s, PAYMENT p  

   WHERE s.ID =p.STAFF_ID;

This will produce the result like this:

STAFF_IDNAMEStaff_AGEAMOUNT
3MONTY252500
1ARYAN223000
4AMIT253500
1ARYAN223000

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *