/SQL/Sql case when exists in another table

Sql case when exists in another table

SELECT A.name, 
       CASE WHEN B.name IS NOT NULL
       THEN 'common'
       ELSE 'not common'
       END

FROM table1 A
LEFT JOIN table2 B
ON A.name = B.name

Source: stackoverflow.com

Similar codes

1 vote140 views1 answer
Psql lst trigger
SQL
2 votes157 views1 answer
Mysql cannot delete or update a parent row
SQL
2 votes152 views1 answer
Use cases condition in sql query laravel
SQL
5 votes140 views2 answers
Mysql drop table cascade
SQL
0 vote168 views1 answer
Import sql inside hide sql
SQL
3 votes158 views2 answers
Sqlite show table definition
SQL
0 vote139 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
4 votes134 views1 answer
Datepart postgres
SQL
3 votes138 views3 answers
C# sql select
SQL
4 votes149 views1 answer
W3schools create table
SQL