What is the difference between the new JOIN operator and the previous ones?

Asked

Viewed 142 times

5

I was looking at some examples of SQL in Oracle, and I noticed that it is possible to do only JOIN.

Example

SELECT
    T1.*,
    T2.desc
FROM
    table1 T1
    JOIN table2 T2 ON T2.id = T1.id_table2

Question

  • What is the difference of that operator?
  • What is the relationship with LEFT, RIGHT? Or he’s the same as one FULL?

Addendum

Related question : What is the difference between INNER JOIN and OUTER JOIN?

sql join
  • 3

    The JOIN is just an abbreviation of INNER JOIN

  • Nothing wrong with your question, just an observation: New JOIN operator? That I know of JOIN without complement is not so new, already exists to a bOOOm time :P

1 answer

10


What is the difference of that operator?

None. JOIN is exactly the same thing as INNER JOIN. It’s just syntax sugar.

In itself documentation of Inner Join of Oracle, it is possible to see that the word inner is in brackets indicating that it is optional.

Syntax 

TableExpression [ INNER ] JOIN TableExpression  
{  
    ON booleanExpression |  
    USING clause  
}

What is the relationship with LEFT, RIGHT? Or it is the same as a FULL?

No relation to LEFT or RIGHT JOIN, neither with FULL/OUTER JOIN.

Browser other questions tagged sql join

You are not signed in. Login or sign up in order to post.