/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 votes274 views2 answers
Spring where to put the data sql
SQL
4 votes276 views4 answers
Pl sql output
SQL
0 vote264 views1 answer
Mysql preg replace
SQL
0 vote280 views1 answer
Timestamp(0) postgresql
SQL
1 vote263 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
18 votes277 views3 answers
Mysql add column default value
SQL
5 votes246 views3 answers
Truncate function in sql oracle
SQL
0 vote263 views1 answer
Min mysql
SQL
0 vote301 views1 answer
New rails app with mysql
SQL
79 votes492 views6 answers
Grepper code
SQL