Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: What does (+) mean in where condition?

    Hi,
    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?
    Regards

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    I was right. I found out article:
    Oracle SQL & PL/SQL: SQL Outer Join
    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •