我必须在mysql中列出收入和费用。snu_idmonth费用表e_typeyearexp_amountselect income.year,income.month,sum(income.inc_amount),sum(expense.exp_amount)
from income,expense.u_id, income.year=expense.year,
- order_id, customer_id;我想得到每个订单的订单值(金额总和我正在尝试此查询:
mysql> select O.order_id, sum(OD.product_sell_price * OD.quantity) from table_order_detailsas OD INNER JOIN table_orders as O where O.order_id = TO
我有一个MySQL表payment,其中我存储了我的客户的所有支付相关的数据。表字段为:fileNo、clientName、billNo、billAmount、status。我不擅长MySQL,但这是我用fileNo编写的版本$sql = "SELECT * FROM `payment` WHERE `clientName` = '$clie