/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 vote148 views2 answers
Installing mysql on centos 7
SQL
9 votes145 views3 answers
Mysql run sql file
SQL
0 vote144 views2 answers
Sql query for getting details by id
SQL
0 vote123 views1 answer
Query on date sqlite flutter
SQL
0 vote141 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote134 views2 answers
Oracle create chain rule
SQL
0 vote134 views1 answer
What is between operator
SQL
0 vote136 views1 answer
Postgres copy command
SQL
0 vote136 views1 answer
How to install sql in anaconda
SQL
1 vote331 views2 answers
Coderbyte sql solutions
SQL