查询1(第一个表-股票)left join reagent r on r.id = s.reagent_id group by r.nameselect sum(t.consumption)as 'stock out total' ,r.name from stock_out s
inner join test_consumption t on s.consumption_id = t.
order_table WHERE order_id ingroup by product
使用这个查询,我得到了产品名称和产品数量那么,当产品获得2个数量时,如何将该数量与产品计数一起与上面的查询相加。在上面的图片中有3个汉堡产品和一个汉堡产品的2个数量,在这里我需要显示类似的产品:汉堡和总数量:4在下一行产品:披萨和总数量:3
我还需要获取发送消息的用户数量。$userlist = mysql_query("select count(distinct m.subject) as msgcnt, u.name from message as m, message_usersmu, users as u where m.owner_id = u.id and m.id=mu.msg_id and mu.user_id='$u_id'group by name") or mysql_error();