/SQL/Select true if exists on another table or false sqlserver

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

Source: stackoverflow.com

Similar codes

14 votes221 views6 answers
Auto_increment mysql
SQL
0 vote180 views1 answer
Opensuse status MySQL
SQL
5 votes193 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote246 views1 answer
Python dictionary to sql update
SQL
15 votes196 views7 answers
MYSQL
SQL
92 votes338 views6 answers
Substring
SQL
0 vote207 views1 answer
Where date in datetime mysql
SQL
0 vote153 views1 answer
Oracle last user logon
SQL
0 vote196 views1 answer
Sql string length postgresql
SQL
8 votes301 views2 answers
Select current_timestamp - interval '3 days';
SQL