/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

2 votes297 views1 answer
Install sqlite npm
SQL
8 votes343 views1 answer
Oracle search stored procedures for text
SQL
7 votes322 views2 answers
What is sql clause
SQL
0 vote336 views1 answer
Sql update subtract value
SQL
0 vote303 views1 answer
Flask sqlalchemy update row
SQL
1 vote317 views1 answer
Update and replace mysql
SQL
0 vote319 views1 answer
Sql select most frequent value in column
SQL
0 vote312 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
4 votes332 views1 answer
Id increment ms sql server
SQL
0 vote342 views3 answers
Call to undefined function mysql_connect()
SQL