Hi, Can any one help me on this : Select T.* , P.col1, Q.col2 from Tab1 T left outer join Tab2 P on T.col1 = P.col1 and T.col2 = P.col2 left outer join Tab3 Q on T.col3 = Q.col3 >> I need to convert this from left outer join to inner join or sub query is also acceptable . This query is for creating view The reason is I want to convert it because I want to convert it to a Indexed view. Need imediate help !!! Thanks, Shashi.