SQL Joins

kinds of SQL joints

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
  • 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

SQL INNER JOIN Keyword

INNER JOIN Syntax

SQL LEFT JOIN Keyword

LEFT JOIN Syntax

SQL RIGHT JOIN Keyword

RIGHT JOIN Syntax

SQL FULL OUTER JOIN Keyword

FULL OUTER JOIN Syntax

SQL Self Join

Self Join Syntax

Ex.

--

--

--

Passionate about ML

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to fix app crashing when using the showFloatWindow API on Huawei devices running EMUI before…

In Search of the Ultimate CMS

The Change-Data-Capture Database Design Pattern

Why the Number of Completed Stories Should Be Your Engineering Team’s OMTM

Genetic algorithm, A* and rotated objects

I’m not a genius

Three things I learned about cluster-management while implementing Wazuh-ELK on AWS

Make Events and APIs easier to find and use

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Wasim Alam

Wasim Alam

Passionate about ML

More from Medium

SELECT statement for SQL

SELECT statement for SQL

Review on SQL Join Operator G T V Eswar gtveswar637@gmail.com

Your Big Data Buzzword Dictionary in 6 minutes

Why should we care about data variety — Structured Data