/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

2 votes151 views1 answer
Change primary key sql
SQL
103 votes2K views1 answer
Like sql
SQL
1 vote154 views2 answers
Pad zero sql server
SQL
0 vote200 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
1 vote156 views1 answer
Sqlalchemy order by descending
SQL
1 vote151 views1 answer
Pv mysql import
SQL
0 vote149 views1 answer
Sql composite key
SQL
1 vote156 views1 answer
Import database from a file using mysql commandline
SQL
4 votes165 views1 answer
SQL find text in SP
SQL
0 vote163 views2 answers
Close external port 3306 with iptables
SQL