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!
To anyone still watching, why is it that the outer join at ruclips.net/video/oXd4mTA86MI/видео.html 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!
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!
To anyone still watching, why is it that the outer join at ruclips.net/video/oXd4mTA86MI/видео.html 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!
Amazing lecture by the prof 👏🏻👏🏻👏🏻
at 19:04, MySQL doesn't support full outer join. Need to use union of right outer join and left outer join
is mam looks like trinity in matrix
És