SQL Joins
SQL joins combine two or more tables based on a common field between them. Here we are describing different types of Joins that are used in SQL below.
Syntax
SELECT tablename1.colunmnname, tablename2.columnname FROM tablename1
JOIN tablename2
ON tablename1.colunmnname = tablename2.columnname
ORDER BY columnname;
SELECT data from Multiple Tables in SQL
The statement is used to retrieve the fields from multiple tables and with the help of JOIN operations we easily fetch the records from multiple tables, Generally JOINS are used when there are common records between two tables. In this article, we will look into various types of JOIN that are used in SQL.