The video demonstrates what are the different types of joins and who they work in SQL.
The tutorial is a little elaborate to make sure that you understand different kind of joins and where you should use which kind of join.
The 5 Kind of joins explained are.
1. Inner join (Join or simple join) :- Rows that are common to both tables are returned as the output.
2. Left Outer join (Left join):- Returns all rows from the left table along with matching rows from the right table
3.Right Outer join (Right join):- Returns all rows from the right table along with matching rows from the left table
4.Full outer join (Full join) :- Returns all the records when there is a match in either left or right table.
5. Cartesian Join : (Join with no where condition)also known as a Cartesian product, is a join of every row of one table to every row of another table.
#OracleJoins #Innerjoin #TechCoach
