/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 vote216 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
1 vote192 views1 answer
Last 24 HOUR data in mysql
SQL
2 votes167 views1 answer
Oracle calculated column
SQL
1 vote191 views1 answer
Psql connect to another database
SQL
0 vote214 views1 answer
Sql anywhere create procedure
SQL
1 vote233 views1 answer
Oracle apex version view
SQL
0 vote181 views1 answer
Mysql pad zeros
SQL
14 votes191 views2 answers
Sql cast
SQL
1 vote167 views2 answers
T sql get foreign key
SQL
0 vote219 views1 answer
Install squirrel sql ubuntu
SQL