Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL [duplicate]

What is the difference in results between:

  1. RIGHT JOIN and RIGHT OUTER JOIN
  2. LEFT JOIN and LEFT OUTER JOIN ?

Can you please explain it through some examples?

like image 451
Puru Avatar asked Jul 06 '10 05:07

Puru


People also ask

What are the difference between rights and duties?

Content: Rights are the privileges given to a citizen which are protected by the constitution but duties are something you are required to do for moral or legal reasons. Rights are what you are constitutionally entitled to while duties are what you are to do concerning the rights.

What is difference between correct and right?

“Correct" is used when referring to the facts about a certain noun. It can refer to proper facts, without any false information or confirming to the rules. You can rely on it, if it's said to be correct. “Right" is something like saying “ok".

What is the difference between right and moral?

Legal principles are based on the rights of the citizens and the state expressed in the rules. An action is permissible if it does not violate any of the written rules. Morality is a body of principles that attempt to define what is good and bad conduct.


1 Answers

There is no difference between RIGHT JOIN and RIGHT OUTER JOIN. Both are the same. That means that LEFT JOIN and LEFT OUTER JOIN are the same.

Visual Representation of SQL Joins

like image 102
18 revs, 6 users 78% Avatar answered Sep 20 '22 11:09

18 revs, 6 users 78%