SQL OUTER JOIN explained

preview_player
Показать описание
A short explanation of what LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN is, examples and visualization via Venn diagrams.
Рекомендации по теме
Комментарии
Автор

Please speak up; I switched videos in my browser and almost went deaf cuz I had overmax my speakers to hear you :(

jacobmoore
Автор

This helped greatly. Should have seen this before my exam. I misunderstood left outer join completely.

nickn
Автор

Every video loses me here. Where do you get Class ON Class.ClassId=Student.ClassId

mmgbtv
Автор

what I still don't understand is what defines on which side the entities will be. You say the left is the student and the right is the class but why what if i would say the class is left and student is right then the whole query wouldn't make sense anymore ??

Ozzieyy
Автор

Classid is foreign to Student table, it makes Classid as foreign key?
Thanks

gooddeedsleadto
Автор

this was one of the worst sql videos ive ever watched

jacobnehama-oit
Автор

Дякую! Найкраще відео з поясненням SQL об'єднання таблиць.

romanromanov
Автор

You're videos help a lot! Thanks! Joins have been fuzzy until today!

DavidAxelrodP