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.