/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

8 votes186 views1 answer
Alter tablespace add datafile
SQL
0 vote199 views1 answer
How to declare variable date in mysql
SQL
1 vote185 views1 answer
Postgres check blocking
SQL
2 votes241 views3 answers
How to replace null values in sql
SQL
1 vote206 views2 answers
Sql server concat string and int
SQL
3 votes183 views3 answers
Mysqldump: couldn
SQL
0 vote197 views1 answer
Test connection to sql server
SQL
15 votes208 views5 answers
Show tables in oracle
SQL
0 vote194 views1 answer
Oracle for loop on list
SQL
5 votes187 views2 answers
Oracle tables with column name
SQL