Revision: 52640
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 28, 2011 12:01 by konami99
Initial Code
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)
Initial URL
Initial Description
Initial Title
left join trick
Initial Tags
Initial Language
SQL