--same CTEs, different main query SELECT Say.M, ROUND(AVG(Say.Votes)) Votes, ROUND(AVG(CASE Split.Y WHEN 04 THEN Split.Votes END)) V_04, ROUND(AVG(CASE Split.Y WHEN 05 THEN Split.Votes END)) V_05, ROUND(AVG(CASE Split.Y WHEN 14 THEN Split.Votes END)) V_14, ROUND(AVG(CASE Split.Y WHEN 15 THEN Split.Votes END)) V_15, ROUND(AVG(Say.Replies)) Replies, ROUND(AVG(CASE Split.Y WHEN 04 THEN Split.Replies END)) R_04, ROUND(AVG(CASE Split.Y WHEN 05 THEN Split.Replies END)) R_05, ROUND(AVG(CASE Split.Y WHEN 14 THEN Split.Replies END)) R_14, ROUND(AVG(CASE Split.Y WHEN 15 THEN Split.Replies END)) R_15 FROM Split, Split Say --Split All Years WHERE Say.M = Split.M GROUP BY Say.M ORDER BY Say.M;