MySQL 多表查询分页
标签：nbsp mit font style div poll mysq sql from
MySQL 多表查询分页
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