Hi, Is there any issue related to usage of limit ? select table1.x1,count(table.x2) from table1 join table2 on table1.x1 = table2.x1 group by x1 limit 20;
This query always picks the first 20 rows from joined table for the group by computation Thanks, Baahu -- Twitter:http://twitter.com/Baahu
