Question

SELECT o.partner_id FROM order o LEFT JOIN partner p on p.id=o.partner_id LEFT JOIN team t on t.id

$sql="SELECT o.partner_id FROM order o LEFT JOIN partner p on
p.id=o.partner_id LEFT JOIN team t on t.id=o.team_id where
o.state='pay' and o.pay_time >= 1364313600 and (( o.rstate !=
'askrefund' and o.allowrefund = 'Y') or o.allowrefund = 'N') and
o.pay_time <= 1364632869 GROUP BY o.partner_id ORDER BY
sum(t.team_price*o.quantity) DESC"; 有什么错

Answer 1

order by后面的字段不在select字段里面