Join with where clause

Hi,

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,

Sunny