MySQL 多表查询分页
时间：2021-07-01 10:21:17
帮助过：43人阅读
v.*, vt.id vid,
vt.vote_id,
vt. option,
vt.poll
FROM
vote v
JOIN vote_option vt
ON v.id
= vt.vote_id
WHERE
v.id IN (
SELECT
t.id
FROM
(
SELECT
id
FROM
vote
ORDER BY
id DESC
LIMIT 0,
2
) AS t
)
ORDER BY
id DESC
MySQL 多表查询分页
标签：nbsp mit font style div poll mysq sql from
