Dear expert,
can we use both sides table in where condition of any
outer join?
can you give me an example.
i want to create one left join for one view and one std. table.
i want to give some condition for both table , and it is depended on selection critera.
but it is giving error to me that can not use right side table in left outer join.
when i remove left join and put inner joint it's worked or when i put comment on tht perticular critrea then also it works but when i put that condition with outer joins then it will work.
please help me.
thanks