06-055-join-operators.mp4

[@toomuchtruth]

Ms. Widom is such a great teacher. Really precise in how she explains things and breaks them down as simple as possible without losing the significance of it. Thanks a lot!

[@winstonyeo4342]

To anyone still watching, why is it that the outer join at kzbin.info/www/bejne/pYnHZaCKdp1pg6s results in three row? Here's my thought process: T2 outer join with T3 results in the table: A B C 4 5 2 3 Outer joining this table with T1 should result in: - no match among the 1st row of T1 and that intermediate table - a match in the 2nd row with the 1st row of T1 therefore, the result in my mind is: A B C 4 5 1 2 3 which is the same as the initial outer join Any clarification would greatly help. thank you!

[@wsyong707]

Amazing lecture by the prof 👏🏻👏🏻👏🏻

[@siyangliang5974]

at 19:04, MySQL doesn't support full outer join. Need to use union of right outer join and left outer join

[@sharkk2979]

is mam looks like trinity in matrix

[@f4lld4ark3]

És