Unanswered: What does (+) mean in where condition?
I use DB2 administrator and I am little bit confused, I got SQL from Oracle that is using (+) sintax in where condition, like:
select table1.col1, table2.col2 from table1, table2 where table1.col1 = table2.col2 (+)
What does this (+) sign means? It is not standard SQL and probably is something like left outer join, is it? So above SQL could be rewritten:
select table1.col1, table2.col2 from table1 left outer join table2 on table1.col1 = table2.col2 (+)
Can you please provide correct standard SQL that would also run on DB2?