56.4 F
San Francisco
Tuesday, August 3, 2021

SQL Joins

I keep forgetting so I’m writing it down here.

Inner Join

Also called Join. This join returns the rows present in both the left table and right table only if there is a match. Otherwise, it returns zero records.

Full Outer Join

Also called as Full Join. This join returns all the rows present in both the left table and the right table.

Left Outer join

Or called as Left Join. This join returns all the rows present in the left table and matching rows from the right table.

Right Outer Join

Also called as Right Join. This join returns matching rows from the left table, and all the rows present in the right table.

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

- Advertisement -spot_img

Latest Articles