Hello and welcome to the forum,
If so can you please help as it an urgent requirement popped up in my team.
You need to understand that we don't do urgent. . .
Why do you believe "distinct" should be considered?
Why do you believe this must be done with a single query?