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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: lonestarbill
- Order by date
-
-
How to rewrite a sub-query
I use this query against an Access database and need to convert it to MySQL. It just does a quick count of active products in each category, and it seems overkill to create temp tables to do this. Is there a way to re-write this using joins? I'm not very experienced with SQL, and everything...- lonestarbill
- Thread
- Replies: 2
- Forum: MySQL
