Mysql select总计和名称
问题描述:
列出客户的名字,姓氏和花费总金额(注意:花费的金额是订单小计+税金+从tblorder表中发货的成本)。Mysql select总计和名称
我有这样的代码(但值都出来一样:
Select CONCAT(firstname, ' ' ,lastname) as name, sum(ordersubtotal + ordertax + ordershipcost) as AmountSpent
From tblorder,tblcust
group by name
答
这应做到:
Select CONCAT(firstname, ' ' ,lastname) as name, sum(ordersubtotal + ordertax + ordershipcost) as AmountSpent
From tblorder a
inner join tblcust b ON a.custId=b.custId
group by name;
你没你是什么定义加入表格
在您的代码风格,将是:
Select CONCAT(firstname, ' ' ,lastname) as name, sum(ordersubtotal + ordertax + ordershipcost) as AmountSpent
From tblorder a,tblcust b
where a.custId=b.custId
group by name;
(两者应该给予同样的结果)
尝试把你的表之间的连接条件。作为一条规则:不要在'from'子句中使用逗号。始终使用明确的“加入”。 – 2015-04-02 03:11:04
idk要加入的是它的名称和custid? – runlax 2015-04-02 03:15:54