SQL Tutorial 5- Joins- Inner, Left, Right, Full Outer

Learn SQL, Introduction to DML: How to do inner, left, right, and full outer join. How do these help us to get data.#sql, #rdbms, #table, #amitchandakda #interviewquestions #interview

Definition Source: Google Search, Wikipedia, IBM, W3School

00:00 Introduction
03:00 Create additional tables
05:00 Inner Join
12:00 Left Outer Join
14:00 Right Outer Join
17:00 Full Outer Join

Last Video: SQL Tutorial 4- Where Clause, Copy Table, Import Data: https://youtu.be/4vAesfpoGfM


select s.Order_No ,
i.item_id item_table_id ,
s.Item_ID
from sales as s
inner join dbo.item as i
on s.Item_ID = i.Item_ID;


select s.Order_No ,
i.item_id item_table_id ,
s.Item_ID
from sales as s
inner join dbo.item3 as i
on s.Item_ID = i.Item_ID;

select count(*) from sales3

select s.Order_No ,
i.item_id item_table_id ,
s.Item_ID
from sales3 as s
inner join dbo.item as i
on s.Item_ID = i.Item_ID;


select s.Order_No ,
i.item_id item_table_id ,
s.Item_ID
from sales3 as s
inner join dbo.item3 as i
on s.Item_ID = i.Item_ID;


select *
from sales3 as s
left join dbo.item3 as i
on s.Item_ID = i.Item_ID;


select *
from sales3 as s
right outer join dbo.item3 as i
on s.Item_ID = i.Item_ID
order by i.Item_ID desc;


select count(*)
from sales3 as s
inner join dbo.item3 as i
on s.Item_ID = i.Item_ID;


select *
from sales3 as s
full join dbo.item3 as i
on s.Item_ID = i.Item_ID
order by i.Item_ID desc;

select count(*)
from sales3 ;



select g.city, i.brand , s.Qty
from Sales as s ,
item as i ,
geography as g
where i.item_id = s.Item_ID
and g.city_id = s.city_id ;



select g.city, i.brand , s.Qty
from Sales as s inner join
item as i on (i.item_id = s.Item_ID )
inner join geography as g on (g.city_id = s.city_id) ;

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
https://www.youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-