I have a query which has all data with respect to a deal, and without a filter of who is owning the deal - the role name, and different sorts of calculations are involved with the query. Now i want to display the whole resultant query into another query, which would do all the calculations and give me the desired output and then put a role filter in the resultant output. Would you suggest a join for it or a master detail realtionship? I tried to do a join with a arbitary query2 with value 1 and the same dataitem in the query 1 and do a join on them , and put the role filter into the query3(that comes from Join). but this is not working. Can someone please suggest any other way of achieving this?