I have a query in pl/sql that i need to migrate to ms sql.

select count(*) from table1 t1 where (conditions1) and (conditions2) and variable = t1.column1(+)

Could anyone tell me what the (+) after the column means ? (is it sort of a sum ?)

  • 1
    Probably better suited for Stack Overflow – James F Aug 11 '09 at 9:33

It's an alternate form of specifying an outer join. There are more details here:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.