/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 vote186 views2 answers
Sql update top 100
SQL
0 vote169 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote183 views1 answer
Postgres set default schema
SQL
5 votes177 views2 answers
Sql number columns
SQL
1 vote180 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote197 views1 answer
Mysql update set sum
SQL
0 vote193 views1 answer
Oracle date winter time
SQL
0 vote174 views1 answer
Learn sqlite dart
SQL
-1 vote180 views1 answer
Mysql #1064 error
SQL
0 vote211 views4 answers
Sql server date format yyyy-mm-dd
SQL