/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

3 votes227 views1 answer
How to uninstall microsoft sql server
SQL
0 vote170 views1 answer
Codeigniter 3 get best-selling products
SQL
13 votes194 views2 answers
Sql join 3 tables
SQL
0 vote181 views2 answers
Sql server Insert Into table
SQL
0 vote170 views2 answers
Update information in a mysql column
SQL
0 vote193 views1 answer
Pagination with row_number
SQL
8 votes174 views1 answer
Today minus 15 days postgresql
SQL
0 vote175 views1 answer
Longtext sql
SQL
-1 vote187 views1 answer
Adding a new table psql
SQL
0 vote183 views1 answer
Sql server select value large text
SQL