Understand Different Type Of Joins In SQL

Joins are query in SQL which are used to join two or more tables and get desired data

Used to return records that have matching values in both tables

Get all records from the left table and matching records from the right table

Get all records from the right table and matching records from the left table

Returns all records when there is a match in either the left or right table

Produces a Cartesian product of the two tables, combining all rows from both

CHECK Other stories

[{"selector":"#anim-50b33858-2530-4158-8c79-e5a2b6bc561c","keyframes":{"opacity":[0,1]},"delay":1400,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3c3ffaa3-e1fa-4320-8906-b520b7c87247","keyframes":{"transform":["translate3d(-105.51725%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1400,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e9a2ead4-dd2f-4826-bfaf-0fbed5169e8b","keyframes":{"opacity":[0,1]},"delay":1700,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7386c14c-4a54-4e82-a51f-15a0b1beaa2a","keyframes":{"transform":["translate3d(-180.0995%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1700,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b55d71da-739e-4e7f-aa9f-6a5fe3073308","keyframes":{"opacity":[0,1]},"delay":1500,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e22833f-da9e-4dc9-bfcb-3e820f371554","keyframes":{"opacity":[0,1]},"delay":1500,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dd8e15fd-0206-4096-95bd-e73162446a50","keyframes":{"opacity":[0,1]},"delay":1500,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f3c247b7-a0fb-4850-8e3e-fe9d5177d4b6","keyframes":{"opacity":[0,1]},"delay":1500,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Understand Different Type Of Joins In SQL

_______________________

By: HIMANSHU GAHLAWAT

Joins are query in SQL which are used to join two or more tables and get desired data

_______________________

What are Joins ?

Used to return records that have matching values in both tables

_______________________

1 - INNER JOIN

Get all records from the left table and matching records from the right table

_______________________

2 - LEFT JOIN

Get all records from the right table and matching records from the left table

_______________________

3 - RIGHT JOIN

Returns all records when there is a match in either the left or right table

_______________________

4 - FULL JOIN

Produces a Cartesian product of the two tables, combining all rows from both

_______________________

5 - CROSS JOIN

CHECK Other stories

Advanced SQL INTERVIEW QUESTIONS

Read Complete article

Master Group by in sql

Learn SQL FOR DATA ANALYSIS

DIFFERENCE BETWEEN JOIN IN SQL WITH EXAMPLE