/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 vote113 views1 answer
Get schema of table sql
SQL
33 votes96 views2 answers
Postgres how to add field created at
SQL
0 vote105 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote99 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote100 views1 answer
Use where instead of join
SQL
1 vote227 views2 answers
Sql unique rows
SQL
0 vote102 views1 answer
Mysql select where field like in list
SQL
0 vote100 views1 answer
Renommer schema sql
SQL
-2 votes117 views2 answers
Union all in sql
SQL
17 votes131 views1 answer
Selecting name that contain certain word in sql
SQL