/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

18 votes107 views4 answers
Mysql current date between two dates
SQL
0 vote128 views1 answer
Sql server insert inner join
SQL
1 vote103 views1 answer
Mysql select row with max value group by
SQL
1 vote113 views2 answers
Datetrunc hour snowflake
SQL
0 vote112 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote115 views1 answer
Sql server Cost Fifo query
SQL
0 vote111 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote117 views1 answer
Create a plsql object
SQL
0 vote116 views1 answer
Primary key multiple
SQL
2 votes71 views5 answers
Alter table primary key postgresql
SQL