That is because you cannot join the same fields over and over again to the same table. In this code, you try to create columns All and SAccess three times in a row. The first time you succeed, creating a column SAccess and a column All containing value 1 for all rows.
The second and third (ouiter) joins will try to use all fields as matching fields (because they all do exist in the table), producing no matches at all since the All field contains 1 all the time.
sorry Manish, this is same as what I have written in the original post. I'll be back with some data, I know its pretty hard to ask these things without data.
as peter suggested, because of that outer join i'm facing this issue, but I tried to perform Noconcatenate here but its throwing illegal combination of prefixes
