INNER join and NATURAL join - Lab Practice | Oracle SQL fundamentals

INNER Join or EQUI Join - This is a simple #JOIN in which the result is based on matched #data as per the equality condition specified in the #SQL query.
Inner Join #Syntax is,
#SELECT column-name-list FROM
table-name1 INNER JOIN table-name2
Natural JOIN - Natural Join is a type of Inner join which is based on #column having same name and same #datatype present in both the tables to be joined.
The syntax for Natural Join is,
SELECT * FROM
table-name1 NATURAL JOIN table-name2;

00:00 Setup tables
02:38 Join Syntax
02:48 Inner Join
02:59 Traditional Join Method
09:15 What is SQL Join Method
11:54 Natural Join