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