mysql query doubt

Question

Hi, my query is as follows:

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

There is the problem when I add the last part WHERE i.id BETWEEN 1418 AND 1518 how I could add extra condition here? Any help??? Thank you

Answer 1

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 d.dtime BETWEEN 1279027200 AND 1279029000
WHERE r.network = "ITPN"
AND i.status = "active"
AND i.id BETWEEN 1418 AND 1518

Answer 2

You have two WHERE clauses, and only one is allowed. See Michael's answer for the correct syntax.