Making Sense of Null Values in SQL Joins: What You Need to Know!

In this video, you'll learn how null values effect different sql join :

TOC:
0:00 Introduction
0:55 Inner Join
2:17 Why null don't match
3:52 Left Outer Join
4:54 Right Outer Join
6:00 Full Outer Join
7:13 Cross Join
8:06 Natural Join
By the end of this video, you'll be able to:

📌 Understand the how null values behave on different types of sql Joins

This video is perfect for :

📌 SQL developers
📌 Data analysts
📌 Business intelligence professionals
📌 Anyone who wants to take their SQL skills to the next level
📌 Data Engineer
Don't miss out! Subscribe for more SQL tutorials!

🔗 𝗝𝗼𝗶𝗻 𝗼𝘂𝗿 𝗟𝗶𝗻𝗸𝗲𝗱𝗜𝗻 𝗚𝗿𝗼𝘂𝗽
➡️ https://www.linkedin.com/groups/9805726/

SQL STATMENTS FOR PRACTIS :

-------------CREATE---------------
CREATE TABLE TABLE_A (ID integer);
CREATE TABLE TABLE_B (ID integer);

-------------INSERT--------------
INSERT INTO TABLE_A VALUES(1);
INSERT INTO TABLE_A VALUES(NULL);
INSERT INTO TABLE_A VALUES(NULL);
INSERT INTO TABLE_A VALUES(NULL);

INSERT INTO TABLE_B VALUES(1);
INSERT INTO TABLE_B VALUES(NULL);
INSERT INTO TABLE_B VALUES(NULL);
INSERT INTO TABLE_B VALUES(NULL);

-----------------------INNER JOIN---------------------------
SELECT * FROM TABLE_A a INNER JOIN TABLE_B b ON a.id = b.id;

-----------------------LEFT OUTER---------------------------
SELECT * FROM TABLE_A a LEFT JOIN TABLE_B b ON a.id = b.id;

-----------------------RIGHT OUTER--------------------------
SELECT * FROM TABLE_A a RIGHT JOIN TABLE_B b ON a.id = b.id;

-----------------------FULL OUTER---------------------------
SELECT * FROM TABLE_A a FULL JOIN TABLE_B b ON a.id = b.id;

-----------------------CROSS JOIN---------------------------
SELECT * FROM TABLE_A a CROSS JOIN TABLE_B b;

-----------------------NATURAL JOIN-------------------------
SELECT * FROM TABLE_A a NATURAL JOIN TABLE_B b;

#sql #join #null #dataengineering #dataanalytics

Видео Making Sense of Null Values in SQL Joins: What You Need to Know! канала ByteOps