/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
LEFT JOIN ( SELECT COUNT(*) AS Counter, YEAR(members.DateCreated) AS MemberYear, MONTH(members.DateCreated) AS MemberMonth FROM ourdeal_backup.members GROUP BY MemberYear, MemberMonth ) AS TotalSubscribingMembers ON TotalSubscribingMembers.MemberYear = YEAR(transactions.DateCreated) AND TotalSubscribingMembers.MemberMonth = MONTH(transactions.DateCreated)