sql select value as true if exists in another table code example
Example: select true if exists on another table or false sqlserver
select A.name,
CASE WHEN B.name IS NOT NULL
THEN 1
ELSE 0
END
from table1 A
left join table2 B
on A.name = B.name