Hi there,

The script provided works but in my case the table 2 is generated and contains data which is a result of other joins

so when i have a left outer join as above i am getting null resulted values from table2

but when i do a inner join there exists match and returns the rows

Please suggest on how to resolve this

My table structure are very big with large quantinty of data so couldn't make a post

Thanks