Thank you Gail. Would check out and work on it.

Firstly, cannot eliminate distinct as the query returns duplicate records.

Secondly, there is overlap of data, so have to use union and not union all.

By eliminating distinct would there be...

This is basically for generating a report.