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

GSoC: Week 1 and week 2

How to Provide Restricted Access to given user in Linux using Rbash

Airdrop Guide — Degis (Avalanche)

Pending Pacts — What Are They Exactly?

Markov Information Binary Sequences Based on Piecewise Linear Chaotic Maps

Creating Fun 3D Pure CSS Hover Flip Card Effect

ZK Hack returns with ZK Hack Mini

A Simple, Useful Fish Shell Prompt for Java/Python Programmers

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

Import/Export Using Apache Sqoop

Difference between SQL and SQLite

Overview Of SQL Stored Procedures (Part 1)

ETL Implementation Using AWS Glue, S3 and PySpark