/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 vote198 views1 answer
Authentication in sql server
SQL
0 vote202 views1 answer
Get last three characters in mysql column
SQL
1 vote208 views1 answer
Name of today sql
SQL
2 votes198 views1 answer
Get first 2 letter in sql
SQL
0 vote250 views1 answer
Alter column to not null with default value sql server
SQL
1 vote201 views1 answer
Select if then postgresql
SQL
0 vote237 views1 answer
Split first name and last name in sql
SQL
0 vote203 views1 answer
How to generate ids in sql
SQL
1 vote224 views1 answer
Mysql Case sum
SQL
9 votes191 views2 answers
Mysql change value
SQL