mysql查询疑问

Question

我的查询如下:

SELECT
r.name
  , r.network
  , r.namestring
  , i.name
  , r.rid
  , i.id
  , d.dtime
  , d.ifInOctets
FROM router AS r
INNER JOIN interface AS i
ON r.rid = i.rid
INNER JOIN 1278993600_1_60 AS d
ON i.id = d.id
AND dtime BETWEEN 1279027200 AND 1279029000
WHERE r.network = "ITPN"
AND i.status = "active"
WHERE i.id BETWEEN 1418 AND 1518

添加最后一部分时出现问题 WHERE i.id BETWEEN 1418 AND 1518 我如何在这里添加额外条件？有什么帮助吗？？？谢谢

Answer 1

您有两个 WHERE 子句，但只允许使用一个。请参阅 Michael 的回答以了解正确的语法。