Select case when i2.id is null then 'false' else true end as 'compare', i1.id,i1.name,i1.gender from info1 i1 left outer join info2 i2 on i1.id = i2.id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)