1

Sorry for the silly question... :)

I found this statement in a query:

select * from table a, table b WHERE a.id =b.id(+)

What does the plus between brackets mean?

Thank you

pacio14
  • 351
  • 1
  • 8
  • 18
  • it's an outer join – pablomatico Nov 07 '16 at 10:58
  • 3
    It is proprietary Oracle syntax for left outer join, dating from before the ANSI SQL standards. The LEFT OUTER JOIN syntax (with the join condition in an ON clause, not in the WHERE clause) is preferred and strongly encouraged even by Oracle. (However, Oracle has some nasty bugs where the ANSI syntax is not understood! Not many though, and you will be much more advanced before you will run into them.) –  Nov 07 '16 at 11:44
  • thank you very much – pacio14 Nov 07 '16 at 12:11

1 Answers1

2

this is outer join and this query is equal to - SELECT A.ID, B.anycol FROM A LEFT OUTER JOIN B ON A.ID = B.ID

Mahesh Patidar
  • 54
  • 2