MySQL Tutorials | MySQL Right Join | Right Joins with examples mysql | Outer join in mysql

This video talks about
MySQL Introduction
what is mysql
introduction of mysql
my+sql=mysql
Introduction to MySQL
MySQL Tutorial For Beginners
mysql advantages
JOINS :
outer joins in mysql
a. INNER JOIN
SELECT LIST OF COLUMNS FROM
TABLE1 JOIN (INNER JOIN) TABLE2 ON TABLE1.DEPTID=TABLE2.DEPTID
b. LEFT JOIN :
EMP and DEPT
LEFT RIGHT
RESULT = COMMON DATA + LEFT OVER DATA in THE LEFT TABLE
== INNER JOIN OUTPUT + LEFT OVER DATA in THE LEFT TABLE
c. RIGHT JOIN :
EMP and DEPT
LEFT RIGHT
RESULT = INNER JOIN OUTPUT + LEFT OVER DATA in RIGHT TABLE

d. Self Join : Kind of Inner JOIN
EMP AND EMP
e. Cross Join :
Result = No of records in EMP * No of Records in Dept

Видео MySQL Tutorials | MySQL Right Join | Right Joins with examples mysql | Outer join in mysql канала Training2SQL MSBI