/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 votes311 views5 answers
Duplicate table sql
SQL
0 vote276 views3 answers
Sql select statements
SQL
0 vote248 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote260 views1 answer
Postgresql import data from csv
SQL
0 vote294 views2 answers
Alter table add multiple columns mysql
SQL
0 vote291 views1 answer
Query params sql insert python f string
SQL
11 votes300 views4 answers
MYSQL LOGIN
SQL
2 votes282 views1 answer
Postgresql drop primary key constraint
SQL
1 vote274 views1 answer
Not exists mysql
SQL
1 vote300 views1 answer
Sql server list locks
SQL