/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 vote268 views1 answer
Postgresql create table default value timestamp
SQL
1 vote307 views1 answer
Sql server delete top 1000
SQL
24 votes303 views5 answers
List mysql users
SQL
2 votes282 views1 answer
Sql count having
SQL
6 votes310 views2 answers
Mysql concatenate two columns into one
SQL
11 votes287 views5 answers
How to install sqlite3 python
SQL
1 vote310 views3 answers
How to create a table structure from another table in mysql
SQL
4 votes972 views1 answer
Oracle show errors
SQL
0 vote279 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote302 views1 answer
Apex for oracle 11g
SQL