Here is a diagram of sql joins for better understanding how they work. This visual representation contains following joins,
- Inner Join
- Left Join
- Right Join
- Outer Join
- Left Join excluding Inner Join
- Right Join excluding Inner Join
- Outer Join excluding Inner Join
Click image to preview.
You can find more details about sql joins from here.
Comments