/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 vote302 views1 answer
Mysql best tutorial for beginners
SQL
0 vote322 views1 answer
Oracle locked objects
SQL
1 vote307 views1 answer
Mysql current running queries
SQL
2 votes292 views2 answers
Join update query in sql
SQL
-1 vote283 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote279 views2 answers
Avg() sql
SQL
1 vote318 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote321 views1 answer
How to find the most occuring in SQL
SQL
2 votes308 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote320 views1 answer
View to table sql
SQL