/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

0 vote140 views1 answer
Firebird where
SQL
1 vote120 views2 answers
Mysql type conversion
SQL
3 votes132 views1 answer
Oracle list privileges
SQL
0 vote147 views1 answer
Arithmetic expression in sql
SQL
0 vote128 views1 answer
Oracle query archive mode
SQL
6 votes118 views5 answers
Get current date sql
SQL
0 vote138 views1 answer
Redudancy in SQL
SQL
0 vote130 views1 answer
Print boolean in plsql
SQL
0 vote142 views1 answer
How to open mysql in docker
SQL
3 votes192 views1 answer
Apex call duration
SQL