Left Join Query for Adding Multiple Tables

preview_player
Показать описание
MySQL - Left Join Query for Adding Multiple Tables
In this video we will learn how to add multiple table in One table using Left Join concept.
Syntax:
SELECT Table1.Column1,Table1.Column2, Table2.Column1,Table2.Column2
Table3.Column1,Table3.Column2… and so on..
FROM Table1
LEFT JOIN Table2 ON CommonColumnofTable1= CommonColumnofTable2
LEFT JOIN Table3 ON CommonColumnofTable1= CommonColumnofTable3
and so on…

Join's Query in MySql Workbench

You can Follow me on My Social Network

Рекомендации по теме
Комментарии
Автор

sir next time please use a lighter topic for an example, the second table

mrudyeupp
Автор

Sir can we use where condition in left join

pradeepravi
Автор

i don't think this makes any difference between inner join and left join since all tables have a match on 'id' column.

spicytuna