SQL Joins Explained In Detail | Example of Inner Join, Left Join, Right Join & Full Join |
SQL JOIN
A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
Different Types of SQL JOINs
(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Returns all records from the left table,
and the matched records from the right table,
The LEFT JOIN keyword returns all records from the left table (table1),
and the matched records from the right table (table2).
The result is NULL from the right side, if there is no match.
RIGHT (OUTER) JOIN: Returns all records from the right table,
and the matched records from the left table
FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table,
The FULL OUTER JOIN keyword returns all records when there is a match in left (table1)
or right (table2) table records.
Note: FULL OUTER JOIN can potentially return very large result-sets!
Tip: FULL OUTER JOIN and FULL JOIN are the same.
You can follow us on the below social media handles:-
Blog: - thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-5...
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a0...
Twitter: - / datamillennials
Пікірлер: 3
Thank you so much
@thedatamillennials
Жыл бұрын
Hi Rita Mathur, I am Glad that our video was helpful . Request you to please help us to reach out to all of those people who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics In case if you are struggling with any topic, Please connect with us on the below given email id and we can connect over a quick google meet call and help you to resolve it. Email Id:- master.datamillennials@gmail.com
@user-xb2tz7yo9c
5 күн бұрын
Thank you