/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 vote119 views1 answer
Resulting Query
SQL
0 vote127 views1 answer
Starting mysql shell lampp ubuntu
SQL
23 votes132 views1 answer
How remove column in mysql
SQL
0 vote128 views1 answer
Oracle swap partition
SQL
38 votes187 views4 answers
Count sql
SQL
0 vote133 views1 answer
Time mysql w3
SQL
0 vote162 views1 answer
Sql count matching group by
SQL
3 votes136 views1 answer
Select database in sql
SQL
7 votes132 views1 answer
Alter sequence set current value oracle
SQL
0 vote128 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL