SQL JOINS: SQL Joins Statements allow us to Access information from two or more tables at once. They also keep our database norm.
Different types of Joins:
1. Inner Join
2. Left Join
3. Right Join
4. Full Join
Inner Join: Returns Dataset that has matching values in both tables.
Left Join: Returns all records from the left table and Matches records from the right.
Right, Join: Returns all records from the right table and matches records from the left.
Full Join: Returns all records when there is a match in either the left table or right table.
#sqljoins
#sqljoin
#InnerJoin #LeftJoin #RightJoin #FullJoin