>SELECT t2.*, > t1.SaleType,t2.TargetSales,t2.ActualSales,t2.IsAchieved > FROM table2 t2 > LEFT JOIN table1 t1 > ON t2.RegionCode = t1.RegionCode AND t2.DepotCode = t1.DepotCode > AND t2.DistrictCode = t1.DistrictCode >>>
>>Table 1 >> >>RegionCode DepotCode DistrictCode SaleType TargetSales ActualSales IsAchieved >>REG001 DEP001 DIST001 Type 1 5678 2345 False >>REG001 DEP001 DIST001 Type 2 1234 2345 True >>REG002 DEP002 DIST002 Type 3 444 444 True >>REG002 DEP002 DIST002 Type 2 11 12 True >>REG003 DEP004 DIST004 Type 9 789 234 False >> >> >>Table 2 >> >>RegionCode DepotCode DistrictCode ValueType TargetPercentage ActualPercentage ValueIsAchieved >>REG001 DEP001 DIST001 VAL001 4 2 False >>REG001 DEP001 DIST001 VAL234 4 4 True >>REG001 DEP001 DIST001 VAL455 2 1 False >>REG002 DEP002 DIST002 VAL111 5 7 True >> >> >>Expected result: >> >>RegionCode DepotCode DistrictCode SaleType TargetSales ActualSales IsAchieved ValueType TargetPercentage ActualPercentage ValueIsAchieved >>REG001 DEP001 DIST001 Type 1 5678 2345 False VAL001 4 2 False >>REG001 DEP001 DIST001 Type 2 1234 2345 True VAL234 4 4 True >>REG001 DEP001 DIST001 null null null null VAL455 2 1 False >>REG002 DEP002 DIST002 Type 3 444 444 True VAL111 5 7 True >>REG002 DEP002 DIST002 Type 2 11 12 True null null null null >>REG003 DEP004 DIST004 Type 9 789 234 False null null null null >> >>>> Any advise on what technique to use would be greatly apprecited.