I am having a problem with Left/Right outer join in which I want to filter the result using where statement for both tables in the join. I got the error that I can't put in the where string the value from the opposite side. For example, if I do left outer join, I can't put in the where string the value in the right table equal to 'E'(where SPRAS = 'E').
I am wondering if anyone can help me with this problem.
Thank you in advance,