![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.18 » View Incident Report |
![]() |
Reported By: codealfa [Code Omega Kft] Reported On: 6/17/2014 For: Version 2.17 Build 1 |
/* BAD: result: 3 */ SELECT COUNT(*) FROM t1 WHERE EXISTS(SELECT * FROM t2 WHERE t2.t1id = t1.id); /* GOOD: result: 2 */ SELECT COUNT(id) FROM t1 WHERE EXISTS(SELECT * FROM t2 WHERE t2.t1id = t1.id); /* GOOD: result: 2 rows */ SELECT * FROM t1 WHERE EXISTS(SELECT * FROM t2 WHERE t2.t1id = t1.id);
This web page was last updated on Tuesday, June 3, 2025 at 08:21 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |