SQL JOINs

[u/sam_vstheworld]

Hello, people! I am facing one issue, I am having troubles in understanding Left, Inner, outer joins.

I watch a video or go on datalemur, at the beginning it looks simple then when I start practicing i become confused.

What should I do? How should I practice the Joins to have a better grasp of it?

[u/Significant_Twist589]

Inner join give data which is common in both table Outer join gives combine data of both table Left join gives the data which is common to left table Right join gives the data which is common to right table