作者:dfpkgih | 来源:互联网 | 2023-08-30 14:45
问题描述
想问下这条语句 怎么样用thinkphp3.23框架 拼接出来sql语句
sql语句
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SELECT
sum( a )
FROM
(
SELECT
s.num * w.width * w.length AS a
FROM
what w
LEFT JOIN star s ON w.sid = s.sid
)
WHERE
s.`name` = 'mark'
GROUP BY
w.sid
ORDER BY
w.time DESC
) aa |