/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

3 votes268 views1 answer
Query less than datetime sql
SQL
8 votes242 views4 answers
Reset SQL auto increment
SQL
0 vote221 views1 answer
Declaring variables in pl sql
SQL
62 votes508 views8 answers
Mysql add column
SQL
-1 vote219 views1 answer
Mysql select count if contains
SQL
0 vote216 views1 answer
Oracle date winter time
SQL
0 vote265 views1 answer
Suhaib
SQL
2 votes195 views1 answer
Oracle index size calculation
SQL
0 vote221 views1 answer
Sql delete dastabase
SQL
0 vote202 views3 answers
Get free card roblox
SQL