/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

0 vote233 views1 answer
Drop CHECK constraint sql
SQL
0 vote214 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote236 views1 answer
Get last date join sql
SQL
16 votes226 views1 answer
Sql comment'
SQL
0 vote224 views1 answer
Extract sql from query object sqlalchemy
SQL
2 votes238 views1 answer
Oracle insert or update
SQL
6 votes229 views4 answers
Mysql group by month
SQL
2 votes227 views1 answer
Set column to not null mysql
SQL
0 vote255 views1 answer
Prisma transaction
SQL
0 vote234 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL