/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

2 votes224 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote148 views1 answer
Sql server split string and insert into table select
SQL
-1 vote144 views1 answer
Sql getdate date only
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
2 votes159 views1 answer
Drop all database tables oracle sql developer
SQL
2 votes113 views1 answer
Sql float to int
SQL
0 vote152 views1 answer
Psql select * from table
SQL
0 vote147 views2 answers
Mysql two column combination unique
SQL
1 vote160 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote167 views1 answer
Mysql get date diff in months
SQL