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!

Register Log in
  • 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: Bubah
  • Order by date
  1. Bubah

    GROUP BY returns 0 records

    I've tried COUNT(*) and still I get 0 records. No error, just no records.
  2. Bubah

    GROUP BY returns 0 records

    This query: SELECT p.Path, p.Title, COUNT(s.ID) AS Total FROM Stats AS s, Paths AS p WHERE s.ID=p.ID AND s.Stamp = '2002-10-03' GROUP BY Path,Title ORDER BY Total DESC LIMIT 10 Returns 0 records. When I remove the COUNT(s.ID) and GROUP BY clause, it works fine. Why can't I get the GROUP BY and...
    • Bubah
    • Thread
    • Replies: 2
    • Forum: MySQL

Part and Inventory Search

Back
Top