/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 vote130 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
10 votes114 views2 answers
Sql merge statement
SQL
2 votes145 views5 answers
Tablespace ORACLE
SQL
0 vote128 views2 answers
What is rownum in oracle
SQL
1 vote105 views1 answer
Postgresql update auto_increment value
SQL
5 votes151 views1 answer
Oracle ora-00054 find
SQL
3 votes112 views1 answer
DB: in eloquent using sql
SQL
0 vote119 views1 answer
Get employees if not contains in sql
SQL
0 vote123 views1 answer
Oracle sql all days except weekends
SQL
0 vote120 views1 answer
How to get specific salary in sql
SQL