/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 vote169 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote165 views1 answer
How to inner join 4 tables in sql
SQL
0 vote156 views1 answer
Porcentaje sql
SQL
0 vote143 views1 answer
Uuid sqlalcomany
SQL
0 vote140 views1 answer
Import big data to mysql
SQL
1 vote142 views1 answer
Update mysql centos
SQL
0 vote173 views1 answer
How to input data as id in database sql c#
SQL
0 vote163 views1 answer
Python dictionary to sql update
SQL
1 vote156 views1 answer
Oracle apex run 404
SQL
0 vote155 views1 answer
Mysql database hyphen
SQL