/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 vote197 views1 answer
How to get n result in sql
SQL
5 votes259 views1 answer
Oracle ora-00054 resource busy
SQL
17 votes198 views3 answers
Cast in sql server
SQL
3 votes199 views1 answer
Postgresql db owner change
SQL
24 votes214 views5 answers
List mysql users
SQL
1 vote191 views1 answer
Funzioni plsql
SQL
1 vote223 views1 answer
Mysql Case sum
SQL
1 vote205 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote246 views1 answer
Postgresql find biggest table
SQL
3 votes203 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL