/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 vote157 views1 answer
Opensuse status MySQL
SQL
0 vote201 views1 answer
Sqlite woth cmake
SQL
0 vote152 views2 answers
Influxdb delete measurement based on date
SQL
1 vote189 views1 answer
Oracle difference between two dates in years
SQL
4 votes196 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote163 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
-1 vote183 views1 answer
Partial search in sql
SQL
5 votes162 views1 answer
Mysql select greater than yesterday
SQL
1 vote196 views1 answer
Postgresql define pk sequence next number
SQL
0 vote171 views1 answer
Psql not found windows
SQL