Combining results from tables that are joined multiple times

Content

Hi,

When I join the same table twice using different conditions, both conditions give different results. The agents may satisfy any one or both the conditions. 

Is it possible to display records from both the tables in one column. How do I combine. 

Tried using variables, if conditions, but nothing was successful.

Anybody who has tried a similar thing?

Appreciate your help.

Thanks,
Geetha