Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
very heavy query
Hi! I have to tables with 50.000 rows (lets say 'sales' and 'detail') The table 'detail' has some rows: 'store', 'departament', 'sub_dep', 'sale_id' that conform a key. The same rows are in the table 'sales'. Now I have to count all the values in table 'details' where certain restrictions...
