Advanced Search

Return to Snippet

Revision: 52640
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