/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 vote285 views1 answer
Duplicate foreign key constraint name
SQL
8 votes318 views3 answers
Oracle auto_increment
SQL
1 vote290 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote309 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
8 votes322 views3 answers
Postgres connection string
SQL
1 vote321 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote328 views2 answers
Py sqlite if entry exists
SQL
0 vote325 views1 answer
Sql server select record with max id
SQL
1 vote312 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
5 votes367 views2 answers
Add days in oracle sql
SQL