Ray helped me build this code to find users with 10 runs. How could I also add criteria that the current date must be included in the runs database?
code from premium support:
SELECT sum(run_QTY) AS runs, users.user_Id, user_First, user_Last, user_Email, user_Pword, user_Size FROM users INNER JOIN runs on runs.user_Id = users.user_Id WHERE user_Received10 = 0 GROUP BY users.user_Id HAVING runs >= 10 ORDER BY user_Last ASC
Could I simply state WHERE user_Received10 = 0 AND runs.run_Date = (date("Y-m-d"))?