While trying to convert some Oracle scripts to SQL server,i got some problems:
In sql server, when using outer join, both terms must contain columns. But in my script, some of them have constant in it

Like in my oracle script ACTL_1.M_ACTL_N_ACTORTYPE(+)=1
can anyone tell me how to do this please.