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 ?)
It's an alternate form of specifying an outer join. There are more details here: