sum 两张表 mysql_mysql查询连接两个表，group by并获取sum

它是关于从按日期分组的加入订单中获取和产品的数量和名称

我有两张桌子:CREATE TABLE IF NOT EXISTS `orderproduct` (

`id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT,

`quantity` int(3) NOT NULL,

`name` varchar(100) NOT NULL,

`fk_orders_id` int(3) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;INSERT INTO `orderproduct` (`id`, `quantity`, `name`, `fk_orders_id`) VALUES

(1, 3, 'Boulgour de bléss', 1),

(2, 2, 'Casarecce d\'épeautre', 1),

(3, 1, 'Cerneaux de noix', 1),

(5, 2, 'Boulgour de bléss', 3),

(6, 2, 'Casarecce d\'épeautre', 3),

(7, 4, 'Casarecce d\'épeautre', 4),

(8, 4, 'Cerneaux de noix', 4);INSERT INTO `orders` (`id`, `date`) VALUES