MySQL Tutorials | MySQL JOINS | Types of Joins in MySQL | What is JOIN in mysql

preview_player
Показать описание
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 :

a. INNER JOIN

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
Рекомендации по теме
Комментарии
Автор

HI Sir,

What is the use of cubes in Power bi..

daytoday