SQL Join || Why SQL Join || Different Type Of Join SQL

SQL JOiN

• As The Name Shows , Join Means To Combine Something. in case of SQL , Join Means To Combine Two Or More Table 
• The SQL Join Clause Takes Records From Two Or More Tables In A Database And Combines Ut Together 
  

∆ inner Join 

∆ Left Outer Join
∆ Right Outer Join

∆ Full Outer Join , and

∆ cross Join

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 Bg Select Statement
• The joining Of Two Or more Table Is Based On Comman Filed between Them
• SQL Inner Join Also Known As Simple Join Is The Most Common Type Of Join

Different type Of SQL Joins

Here Are The difference Types Of The Joins In SQL:

• Inner Join :- Returns Records That Have Matching Value In Both Tables 
  
• Left Outer Join :- Returns All Records From The Left Table , And The Matched Records From The  Right Table.
• Right Outer Join :- Returns All Records From The Right Table And The Matched Records  From The Left Table.
• Full Outer Join :- Returns All Records when There is a Match In Either Left or Right Table.