/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 vote236 views1 answer
Oracle list subpartitions
SQL
4 votes268 views3 answers
Sql find second highest salary employee
SQL
2 votes234 views2 answers
Mysql on duplicate key ignore
SQL
0 vote243 views1 answer
Connecting to my cloud sql server with c#
SQL
2 votes254 views1 answer
Sql server find columns list in tables
SQL
-1 vote241 views1 answer
Get id from just inserted row mysql server python
SQL
5 votes267 views2 answers
Add days in oracle sql
SQL
6 votes217 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote235 views1 answer
How to drop function in sql
SQL
1 vote236 views1 answer
Sql padd let with zeros
SQL