MySQL exists and in have different result

By Richard.H

SELECT * FROM commodity WHERE id IN (SELECT cid FROM specifications s WHERE s.id<600);

SELECT * FROM commodity WHERE exists(SELECT c.* FROM specifications s,commodity c WHERE s.id < 600 and c.id = s.cid );

why this two have different results?

how can I get the same results if I want to change one to exists style?

Source: Stack Overflow

    

Share it with your friends!

    Fatal error: Uncaught Exception: 12: REST API is deprecated for versions v2.1 and higher (12) thrown in /home/content/19/9652219/html/wp-content/plugins/seo-facebook-comments/facebook/base_facebook.php on line 1273