/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

3 votes138 views1 answer
Define REGEXP?
SQL
-1 vote106 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote135 views1 answer
Mysql could not fetch tables
SQL
1 vote302 views1 answer
Postgres upgrade to superuser
SQL
1 vote118 views2 answers
Mysql: command not found
SQL
0 vote125 views1 answer
Oracle search in date columns
SQL
0 vote124 views1 answer
Datagrip execute procedure
SQL
0 vote132 views1 answer
Mysql order by where condition sub query
SQL
0 vote123 views1 answer
Multiple tricky query in sql server
SQL
0 vote109 views1 answer
Truncate table sql server foreign key
SQL