/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 vote213 views1 answer
Datagrip exec
SQL
0 vote216 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote216 views1 answer
Copy value from one column to another postgres
SQL
6 votes221 views4 answers
Delete table sqlite
SQL
0 vote202 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote213 views1 answer
How to change mysql port in xampp
SQL
0 vote225 views1 answer
Oracle change password expiration policy
SQL
1 vote231 views1 answer
Replace all numbers in mysql
SQL
0 vote215 views1 answer
Mysql command line ubuntu
SQL
2 votes218 views1 answer
Mysql clear screen
SQL