Рет қаралды 277,473
Explanatory video on the operation of JOIN clauses in SQL.
In this case, the scripts correspond to SQL Server, but they work in the same way for the other relational database engines, such as MySQL, PostgreSQL, SQLite, etcetera.
📚 Table of contents
00:00 → Introduction
00:53 → Data sample description
01:29 → Create database
02:49 → Inner JOIN
02:59 → Left JOIN & Right JOIN
09:22 → Full JOIN
11:00 → Left Excluding JOIN
13:45 → Right Excluding JOIN
14:05 → Outer Excluding JOIN
You can find the examples in this blog article:
programacionymas.com/blog/com...
*****
📚 Learn more at:
Our website ► programacionymas.com
Facebook ► / programacionymas
🚀 Can you help me reach 50k subscribers? ►
bit.ly/SuscribirmePYM
*****
👋 Thanks for watching!
If you have any questions, leave a comment below.
Also remember to like and share the video.