/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 vote135 views1 answer
Sql clear table
SQL
0 vote131 views1 answer
Call function sql oracle
SQL
0 vote134 views1 answer
Mysql concat and use as where column
SQL
-2 votes143 views1 answer
Group functions in sql
SQL
9 votes144 views2 answers
Nosql databases
SQL
0 vote143 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote152 views1 answer
Change magento database url usimg musql
SQL
0 vote143 views1 answer
Mysql xampp reset root password
SQL
5 votes231 views2 answers
Mysql date greater than 30 days
SQL
0 vote151 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL