symbol in sql query

Question

Just i have came across a SQL query in one of the stored procedure like below:

SELECT 
    * 
FROM 
    account a, 
    performance p,
    customer c, 
    override o
WHERE 
    a.account_id = p.account_id (+)
    AND a.account_id = c.account_id (+)
    AND o.override_type(+) = 'O'

Can you please explain what is the (+) symbol's play here? and the difference of using Left side and right side.

Answer 1

This symbol refers to old syntax to implement outer join in oracle. But now it’s better to go with full outer, Left, or right join syntax provided by SQL.

Interested in SQL Server? Here is the SQL Training provided by Intellipaat.