OUTER JOIN in SQL

[@garyxu4013]

Typo : for the right join, I believe it should be L4 for the borrower.loanno for the last row

[@shrutikachippa2253]

Yeah ... it's l4

[@adarshranjan9629]

@@shrutikachippa2253 yes, it should be L4

[@sudarshankhasnis3187]

Can you give an example for stated after ON in the syntax?

[@shrutipatil6706]

which software you use to write on screen
in the videos

[@suraneniajay2313]

easy to understand :), the way of explanation is very good. Anyone can understand the topic at any cost.

[@edwardsheats7453]

Great and easy explanation of all three outer joins, thank you

[@lit2ac]

so ironic

[@alirezasamadi5804]

it was really helpful you described so simply that I understood by watching a few minutes of video

[@animeshrose]

You saved my hours of work. Thank You so much.

[@assemhussein6246]

I just wandering if we using (+) operator to solve left outer join and right outer join \\\
Right Outer-join :
select L.loan_no , branch , amt , cust_name , B.loan_no
from loan L , borrower
where B.loan_no = L.loan_no(+) ;
Left Outer_join :
select L.loan_no , branch , amt , cust_name , B.loan_no
from loan L , borrower
where B.loan_no(+) = L.loan_no ;
could u please tell if that is right , and how we can use full outer join using (+) operator . And thank u

[@anjucome6246]

Very very useful session. Thank you.

[@KSNR-SupplyChain_Mastery]

GOOD EXPLAINATION SEEING TO WORTH.......

[@kodiq3429]

2 minutes od watching abd I understood everything. Thanks

[@satrinakelley-jordan6418]

Thanks for this...extremely helpful!

[@renukajadhav7795]

Right outer join n full outer join is not cleared by d sam eg

[@rubenm7501]

Very clear explanation of Outer Joins. Thank you for the video!

[@JaneDoe-uk2es]

Besides the aforementioned mistake, very helpful. Thank you!

[@chiragpatel1603]

Right outer join result shown wrong in your example.

[@Btech_Food_Wali]

I never understood the cocepts of joins but after watchkng his videos i csn say that i know joins anyone can ask me question from joins🎉❤

[@acutespike9260]

So what is the difference between full join and full outer join, left join and left outer join, right join and right outer join? :D

[@polnapanda4934]

It's been two years, ok so there is no diffrence :)

[@vittalprabhu379]

It's been four years, ok so there is no difference :)

[@moazzamabatool1607]

If there is a not same columns no joining can take place...

[@idahomeadventures1630]

The right outer join had me really confused with the mistake in the video. I paused it and was trying to understand how in the world there was all of a sudden an L3 in the right table. Little did I know that the mistake was fixed in a later segment of the video. I wish it was addressed though so that it doesn't confuse anyone else.

[@saicharan4669]

Simple and awesome explanation

[@Himanshu_85-e2i]

Good vedio sir I understand with fully concept sir really awesome vedio sir

[@princek1943]

Right outer join is wrong l3 ,in place of l4

[@divinity5250]

Thank you for removing my confusion for joins👍☺️

[@khmersong9280]

you explained very clear Thank you so much

[@navishkanuwan6720]

Do a question at leat w out just displaying the answer. Not satisfied

[@rafaelernestobecerrarojas1883]

good explanation

[@minalbarge7940]

Very helpful......Thank you

[@ashokkumarp9334]

Much appreciated ❤️ thank you

[@limamil10]

I appreciated you explanation! Very useful.

[@rahulachapale3393]

Stop all ads

[@mohammadshams6519]

very clear ............... hanks alot

[@AshokKumar-eh2ry]

I enjoyed a lot sir

[@raiyanreza9764]

nicely done!

[@dipalidhamale9267]

Helpful

[@Sonam-qf9je]

Thankyou

[@t_sathis]

simple and clear, but very effective
thanks

[@ravindrakumar-po3ep]

Good

[@Sonam-qf9je]

🥰

[@daif_academy]

best

[@김동규-g2t]

okay? okay~ :)

[@dxniel2723]

YA SAHBI

[@itreportcambodia8283]

HI B

[@lit2ac]

honestly I m a Diploma student even found lots of mistakes....

[@chandanpandey1847]

Bata jara 2mistake toh..

[@ainextgen24]

Good