/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 votes193 views4 answers
Show databases in sql server
SQL
0 vote163 views1 answer
Mysql with
SQL
0 vote199 views1 answer
PSQL use LIKE with timestamps
SQL
-1 vote209 views2 answers
Sql search all tables for attributes
SQL
0 vote179 views1 answer
Alter boolean column postgresql
SQL
0 vote184 views1 answer
Copy data from one postgres container to another
SQL
0 vote171 views1 answer
Get created time of database psql 8
SQL
9 votes191 views2 answers
Sql server check table exists
SQL
19 votes206 views6 answers
Create table sqlite
SQL
0 vote184 views2 answers
Get top 1 row of each group
SQL