/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 vote173 views1 answer
Create api project in visual studio 2019 and sql server
SQL
1 vote199 views1 answer
Flask sqlalchemy default value
SQL
0 vote150 views1 answer
Sql count how many times a value appears
SQL
0 vote215 views1 answer
Add mysql database to power bi web
SQL
12 votes254 views10 answers
Google
SQL
0 vote190 views1 answer
Postgresql create user roles
SQL
0 vote425 views1 answer
Sql datum formatieren
SQL
1 vote202 views1 answer
Delete from inner join sql
SQL
8 votes214 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote195 views1 answer
Oracle sql winter time change
SQL