/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

3 votes105 views2 answers
Create schema postgres
SQL
3 votes105 views2 answers
Sql add year to date
SQL
12 votes104 views4 answers
Mysql version query
SQL
0 vote98 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
6 votes141 views3 answers
Mysql change auto_increment start value
SQL
1 vote105 views1 answer
Sql server datetime vs datetime2
SQL
8 votes124 views4 answers
Reset SQL auto increment
SQL
0 vote115 views1 answer
How to locate pg_hba.conf file
SQL
5 votes111 views1 answer
Oracle nls parameters
SQL
0 vote99 views1 answer
Oracle last user logon
SQL