/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 votes398 views2 answers
Synonym oracle
SQL
0 vote438 views1 answer
Mysql get nested records
SQL
9 votes340 views2 answers
Sql limit order by
SQL
0 vote395 views1 answer
What is metadata in sql
SQL
0 vote366 views1 answer
Copy data from one postgres container to another
SQL
0 vote358 views1 answer
Copy data from cell to cell mysql
SQL
0 vote354 views2 answers
Starting mysql service from mac
SQL
4 votes352 views4 answers
Print pl sql
SQL
6 votes336 views2 answers
Mysql set primary key
SQL
0 vote383 views1 answer
Contraint default SQL
SQL