Thank you, it is working fine

I will try using your suggestion.

For Eg:

Table 1

groupdata1data2data3

ONE607080

TWO304050

Table2

Namegroupdata1data2data3

SASYONE100

SANYTWO010

Result

Namegroupdata1data2data3

SASYONE6000

SANYTWO0400

If data1,2,3, column is 1 , fetch its corresponding value from table1, if 0 remain same