Re: SUM IF totals help

[Andrew Adcock]

could the following work??

CREATE TABLE IF NOT EXISTS `bdgt_month_year_combo` (
  `month_year_combo_id` int(11) NOT NULL AUTO_INCREMENT,
  `monthly_budget_id` int(11) NOT NULL,
  `select_month` date NOT NULL,
  PRIMARY KEY (`month_year_combo_id`),
  KEY `month_year_combo_id` (`month_year_combo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `bdgt_month_year_combo`
--

INSERT INTO `bdgt_month_year_combo` (`month_year_combo_id`, `monthly_budget_id`, `select_month`) VALUES
(1, 5, '2010-01-01'),
(2, 5, '2010-02-01'),
(3, 5, '2010-03-01'),
(4, 5, '2010-04-01'),
(5, 5, '2010-05-01');