/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 vote347 views1 answer
Google sheets filter rows above current cell
SQL
9 votes394 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote366 views1 answer
Java sql connection
SQL
36 votes422 views6 answers
Change column data type sql
SQL
1 vote394 views3 answers
How to pass password to mysql command line
SQL
0 vote398 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote330 views1 answer
Drop check command
SQL
2 votes355 views3 answers
Oracle show column of table
SQL
0 vote360 views1 answer
Raven ql select count
SQL
0 vote346 views1 answer
Difference between varchar and varchar2
SQL