Advanced Search

left join trick

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. LEFT JOIN (
  2. 				SELECT COUNT(*) AS Counter, YEAR(members.DateCreated) AS MemberYear, MONTH(members.DateCreated) AS MemberMonth 
  3. 				FROM ourdeal_backup.members
  4. 				GROUP BY MemberYear, MemberMonth
  5. 			) AS TotalSubscribingMembers 
  6. 			ON  TotalSubscribingMembers.MemberYear = YEAR(transactions.DateCreated)
  7. 			AND TotalSubscribingMembers.MemberMonth = MONTH(transactions.DateCreated)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.