SQL tutorial 28: Left Outer Join By Manish Sharma / RebellionRider 

Thank you Manish for the videos. What really made a difference in this video was when you stopped and showed us the source, target and result tables. Don't be in a hurry to do the tutorias very short. I think the people who are watching your videos want as much detail as possible. Please don't think that it is redundant at all. I think the more you repeat yourself, the easier it gets for us. Much appreciation for the time spent planning, recording and editing your videos. Hope to see many more with more details!

Man... U r so underrated.... Thanks for saving us.

Good one Manish!!! Now there is clarity on right outer join after watching video on left outer join. Good work. Keep Going.

Thank you Manish, I have been working on this query for days and you explained it better than my professor. I never comment but, I had to let you know you did a great job. I followed your explanation and got my query to run perfectly within minutes. You are awesome!

This tutorial has a far better and easy explanation than the right outer join tut....Useful..Thanks!

You are MIT (not just IIT) Material. I wish you the very good in life !

God Bless You Manish please make an elaborate video on right outer join. I wish I could get a tuition in person with u. keep up the good work

Thanks bro for providing Oracle Tutorials. I got to learn a lot from the videos. Bless you :)

Superb video lecture on JOINS... It's not just a video lecture, you represented in away with great articulation and understandable diagrammatic representation. Thanks..Cheers!

your tutorials are every good and are very helpful. keep doing the great job man

This video is very helpful in explaining joins.Thanks and much appreciated.

Manish Bhai, Thanks for all the videos you make. You are brilliant! Make the video a little slower so we can catchup!

Thank you Manish. Your tutorial is helpful !

Thanks Manish for your tutorials, really helpful.

dear brother manish you are awsome. , it will be more helpful for people like me who are really new in sql ,if you go little slow. but thanks a lot

It is really helpful and easy to understand. Thanks a lot

Very Nice and Simple to understand

hi how are you? i saw ur videos it is very useful for me thank you so much

Manish I truly thank you for these videos. Your efforts are greatly appreciated. I am curious why your graphic explanation for LEFT OUTER JOIN, the source table is on the right side?

Excellent video

THANK U MANISH, CAN U EXPLAIN THE EXECUTION FLOW OF SUB-QUERY AND CORRELATED SUB QUERY IN UR VIDEO...?

Thanks you Manish ....(I have never given any comment to any video on yt.. this one is special for u)

hi manish, can u plz upload a tutorial on self-join? i'm very confused with self join concept. thank you

Well Explained. Thanks a lot

Hi Manish, first of all thanks for the videos and the thing is i had questions of "what are the uses of left outer join?" and "what are the uses of other joins individually "

Thanks a lot man

this video is like crystal because it is very helpful but hard to find...

How will you know which table we need to select as a source ? Can you give an example of how to choose and in which senarios we chose a table as source and other as target.

thanku so much

You are great

Hi Manish, I have a question. if the column which is used in join condition is not a primary key, i. e. it appears in the target table more than once, then will the query throw an error?

bro in your previous right join tutorial Emp is source and dept is target table but in this tutorials it is vice verse why?

Great !

How will one understand which table to take as source table and which as target

There is no blog post for "left outer join"

Hi can you please tell me why i am getting here 14 records.my saying is is i am selecting only 6 records from left table and matching with right table then why i am getting here 14 records.please answer me. SELECT EMP.ENAME, EMP.DEPTNO, DEPT.DEPTNO, DEPT.LOC FROM EMP LEFT OUTER JOIN DEPT ON EMP.DEPTNO=DEPT.DEPTNO AND EMP.DEPTNO=30

great

good

Some good info in here, however, you speak so rapidly and your accent is so strong, it is sometimes difficult to understand what you are saying as the words run into each other. Slow down and enunciate CLEARLY and your tutorials will be much improved. Dannyavad.

parent child join