What does "(+)" mean in SQL syntax?

Asked Apr 02 '14 at 03:19

Active Apr 02 '14 at 05:42

Viewed 136 times

I came across a SQL join syntax as follows:

Select
ColList
From 
Tablename1, Tablename2
Where
Tablename1.ColName (+)= Tablename2.ColName
And
Tablename1.ColName2 = Tablename2.ColName2

Now I understand the basic SQL join syntax but (+) sign is little confusing. Can someone please explain me what this (+) sing means? Thanks

edited Apr 02 '14 at 05:42

asked Apr 02 '14 at 03:19

Aniket

1

Also possibly [What does `(+)` do in a WHERE clause?](http://stackoverflow.com/questions/430274/oracle-what-does-do-in-a-where-clause) – Jonathan Lonowski Apr 02 '14 at 03:27
this was already asked, found the correct answer here: http://stackoverflow.com/questions/6559261/left-outer-join-using-sign-in-oracle-11g – Aniket Apr 02 '14 at 15:57

0 Answers0