/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 vote178 views1 answer
Mysql backup skip table
SQL
3 votes189 views1 answer
Mysql insert on dupèlicate
SQL
1 vote168 views3 answers
Epoch to datetime
SQL
0 vote166 views1 answer
Time mysql w3
SQL
0 vote157 views1 answer
Strat with in sql
SQL
0 vote180 views1 answer
Group by join columns per table
SQL
0 vote178 views1 answer
Database traccar
SQL
2 votes177 views1 answer
Columns Present in a table
SQL
0 vote163 views1 answer
Mysql select last 15 minutes
SQL
13 votes187 views5 answers
Alter table query sql server change column
SQL