/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 vote132 views2 answers
Psql commande \gset
SQL
0 vote139 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote143 views1 answer
Snowflake rename column name
SQL
0 vote155 views1 answer
Synapse sql table set pk
SQL
1 vote139 views1 answer
Show per page table in xampp
SQL
40 votes196 views6 answers
Update table mysql
SQL
13 votes126 views6 answers
Current date sql
SQL
0 vote121 views1 answer
Mysql table variables
SQL
0 vote154 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote135 views1 answer
Sqlite referential integrity
SQL