Código SQL:
Ver originalCREATE TABLE #temp2
(
id INT,
value1 VARCHAR(20),
value2 VARCHAR(20)
)
INSERT INTO #temp VALUES (1)
INSERT INTO #temp VALUES (2)
INSERT INTO #temp2 VALUES (1,'1','2')
INSERT INTO #temp2 VALUES (1,'2','1')
INSERT INTO #temp2 VALUES (1,'3','1')
INSERT INTO #temp2 VALUES (2,'1','2')
INSERT INTO #temp2 VALUES (2,'2','3')
INSERT INTO #temp2 VALUES (2,'3','4')
SELECT t1.id,t2.value1,t2.value2 FROM #temp AS t1 LEFT JOIN (
SELECT value1,value2,id FROM(
SELECT value1,value2,id, ROW_NUMBER() OVER(PARTITION BY id ORDER BY id) AS rn FROM #temp2 )t3 WHERE rn=1
) AS t2 ON (t1.id=t2.id)
WHERE t2.id IS NOT NULL