作业帮 > 综合 > 作业

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

来源:学生作业帮 编辑:拍题作业网作业帮 分类:综合作业 时间:2024/04/26 06:16:00
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
order by后面的字段不在select字段里面