case when

 SELECT t1.id,case when t1.id =t3.id then 1 else 0 end as isselected
FROM   dbo.test1 t1 LEFT OUTER JOIN
               dbo.test3 t3 ON t1.id = t3.id