Not exists mysql

SELECT DISTINCT store_type FROM stores
WHERE NOT EXISTS (SELECT * FROM cities_stores
                    WHERE cities_stores.store_type = stores.store_type);

Source: dev.mysql.com

Similar codes

0 vote207 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote203 views1 answer
Call function in query sql server
SQL
5 votes184 views2 answers
Get number of columns sql
SQL
10 votes221 views4 answers
Mysql one week ago
SQL
0 vote176 views1 answer
How to install sql in anaconda
SQL
0 vote189 views1 answer
Geopoint from json mysql function
SQL
1 vote194 views1 answer
How to see all table partition in oracle
SQL
9 votes172 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote181 views1 answer
Mysql update privileges
SQL
1 vote176 views1 answer
Reutrn string after character sql
SQL