/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

4 votes268 views2 answers
Oracle unlock user
SQL
0 vote265 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote276 views1 answer
SQL query to verify the size of the table
SQL
2 votes289 views3 answers
How to check current user in mySQL
SQL
0 vote273 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote289 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote267 views2 answers
Soql last year
SQL
-2 votes291 views2 answers
Add auto_increment column to existing table mysql
SQL
11 votes255 views2 answers
Safe mode off mysql
SQL
0 vote280 views1 answer
Oracle sql add column auto generated value
SQL