The above query you provided is good, but the performance is not up to the mark.

Actually below is the logic i am looking for.

M intersection D' (M∩D')

conditon -- retrieve dataset...

Yes, my original code is working.

One more thing i forgot to mention that the above query is a "view" as we cant use #temp tables in that.