Skip to Content
0
Former Member
Jul 27, 2005 at 08:45 PM

Join with where clause

69 Views

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