The Little Guy Posted August 10, 2008 Share Posted August 10, 2008 Why is this only returning 5 results? It should return 6. The second select returns two rows count of "males" and count of "females". When run individually they all return the correct results. (SELECT COUNT(id) AS count FROM users) UNION (SELECT COUNT(id) as count FROM users GROUP BY gender) UNION (SELECT COUNT(id) as count FROM images) UNION (SELECT COUNT(id) as count FROM videos) UNION (SELECT COUNT(id) as count FROM events) UNION (SELECT COUNT(id) as count FROM leagues) Link to comment https://forums.phpfreaks.com/topic/118985-not-enough-rows-returned/ Share on other sites More sharing options...
toplay Posted August 10, 2008 Share Posted August 10, 2008 UNION by default removes any duplicates from the results. So, use UNION ALL if you want dups returned. Link to comment https://forums.phpfreaks.com/topic/118985-not-enough-rows-returned/#findComment-613049 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.