SQL Tutorial - 4 SQL Joins Inner Join Outer Join Self Join Cross Join
A join is a query that extracts data from two or more tables, views or snapshots or we can say A join is a query that combines rows from two or more tables, views, or materialized views.
Types of join
INNER JOIN
1 Equi join
2 Non Equi join
OUTER JOIN
1 Left outer join
2 Right outer join
3 Full outer join
SELF JOIN
CROSS JOIN
For more update like my page on facebook on below link
/ pravendragaur.biz
You can also Email me at
for E-mail address please check About section
Please please LIKE and SHARE my videos it makes me happy.