Skip to Content
0
Nov 05, 2008 at 09:52 AM

Error showing while left join

36 Views

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