Its not that way Lutz i am actually very new to SQL coding and i am not able to understand or get how exactly i can write the question in...

FcHistory.dbo.tdwClaims A

FcCore.dbo.tCMMembers TM on A.MemberID = TM.MemberID

FCHistory.dbo.tdwclaimTransactions CT on A.ClLineID = CT.ClLineID

FcCore.dbo.tPlans TP on A.PlanID = TP.PlanID

These are all the tables from which i am extracting the data required to...

What exactly you want me to provide LUTZ.

Thanks & Rgrds,

Vinod