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

Question

Navigation

#1 by (8 votes)

4

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

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

sql join

asked by anonymous 30.03.2017 / 14:07

1 answer

Select Float Mysql How to separate only the first word from each string in a list?

score 8 · Accepted Answer

What is the difference of this operator?

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

In the inner join documentation of Oracle, you can see that the inner tag is enclosed in brackets, indicating that it is optional.

Syntax

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

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

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