DECLARE @table1 TABLE (
	[group] VARCHAR(50)
	, [data1] INT
	, [data2] INT
	, [data3] INT
	)

DECLARE @table2 TABLE (
	[name] VARCHAR(50)
	, [group] VARCHAR(50)
	, [data1] INT
	, [data2] INT
	, [data3] INT
	)

INSERT INTO @table1
      SELECT 'ONE', 60, 70, 80
UNION SELECT 'TWO', 30, 40, 50

INSERT INTO @table2
      SELECT 'SASY', 'ONE', 1, 0, 0
UNION SELECT 'SANY', 'TWO', 0, 1, 0

SELECT
	t2.[name]
	, CASE t2.[data1] WHEN 1 THEN t1.[data1] ELSE 0 END
	, CASE t2.[data2] WHEN 1 THEN t1.[data2] ELSE 0 END
	, CASE t2.[data3] WHEN 1 THEN t1.[data3] ELSE 0 END
FROM
	@table2 t2
	JOIN @table1 t1 ON t1.[group] = t2.[group]

quote:

---

Originally posted by Db_new

Thanks for the reply

If the table2 data colum is 1, it should take the balue from table1 , if the value is 0, then it should be 0


Eg

Table 1
group data1 data2 data3
ONE 60 70 80
TWO 30 40 50

Table 2
Name group data1 data2 data3
SASY ONE 1 0 0
SANY TWO 0 1 0


Result

Name group data1 data2 data3
SASY ONE 60 0 0
SANY TWO 0 40 0

Please help me

---

SELECT t2.Name,t2.group,
t2.data1*t1.data1 as data1,
t2.data2*t1.data2 as data2,
t2.data3*t1.data3 as data3
FROM Table2 t2
JOIN Table1 t1
ON t2.group=t1.group