/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

-1 vote285 views1 answer
MYSQL stored procedure select from
SQL
3 votes317 views4 answers
Ubuntu stop mysql
SQL
1 vote281 views1 answer
Oracle user last connected
SQL
32 votes318 views6 answers
Insert select
SQL
0 vote333 views1 answer
Create-table-with-index-organization
SQL
0 vote322 views1 answer
How to create notes in mysql
SQL
0 vote282 views1 answer
Drop all tables in azure sql database
SQL
1 vote271 views1 answer
Python escape string for sql
SQL
5 votes329 views1 answer
Get column name sql server
SQL
44 votes344 views6 answers
Rename command in sql
SQL