Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by dev.mysql.com #
 
PREVIOUS NEXT
Tagged: #exists #mysql
ADD COMMENT
Topic
Name
8+3 =