使用另一个Query的结果集连接多个表

I need to join multiple tables along with the result set of a select query which itself uses a UNION operator to get data from two tables. The following query is not giving any error but returns no data whereas the data exist. Please tell me what is wrong in this query. How can I achieve this. I need to join multiple tables along with the r