/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 vote277 views1 answer
How to create a table in sql stack overflow
SQL
0 vote286 views1 answer
Authentication in sql server
SQL
1 vote278 views1 answer
Raw query must include primary key
SQL
0 vote306 views1 answer
Bitmap join index
SQL
3 votes280 views2 answers
Mysql create timestamp column
SQL
5 votes275 views1 answer
Oracle find foreign key dependencies
SQL
14 votes302 views2 answers
Oracle limit rows
SQL
3 votes253 views1 answer
System.debug apex
SQL
2 votes299 views1 answer
Q operator in plsql
SQL
0 vote274 views1 answer
Sql server convert date to weekday
SQL