By using joins, we can retrieve data from two or more tables based on logical relationships between the tables. Joins indicate how SQL Server should use data from one table to select the rows in another table. Based on the two conditions such as by specifying the column from each table to be used for the join. And a typical join condition specifies a foreign key from one table and its associated key from the other table.
SQL Joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is a relationship among some columns in the data tables that take part in SQL join. Basically, database tables are related to each other with keys. We use this keys relationship in SQL Joins.
Types of SQL Joins
In SQL Server we have only three types of joins. Using these joins we fetch the data from multiple tables based on condition.
1. Inner Join
2. Outer Join
3.query Cross Join
4. Self Join
