/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 vote350 views1 answer
Get number of tables in database sql
SQL
8 votes410 views1 answer
See all users mysql
SQL
0 vote386 views1 answer
Mysql 3 months ago
SQL
1 vote389 views4 answers
Psql check tables command
SQL
1 vote368 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
16 votes435 views2 answers
Sql vs nosql
SQL
0 vote369 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote362 views2 answers
Mysql between
SQL
0 vote345 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote386 views1 answer
Prodection ready postgres database step by step
SQL