Query WHERE clause and JOIN I'm having an issue using a WHERE clause and JOIN.

SELECT * FROM `CallDetailRecord` 
  WHERE `StartTime` &gt;=1357102799000 
  AND `StartTime` &lt;=1357880399000 
  JOIN `CallEvent` ON `EventID` = `CallEventID`



  Error Code: 1064
  You have an error in your SQL syntax; check the manual that corresponds to your MySQL       server version for the right syntax to use near 'JOIN CallEvent ON EventID = CallEventID
  LIMIT 0, 1000' at line 1


Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0.004 sec
---------------------------------------------------


I'm just trying to limit data set by time "starttime', but I get query error and it refers to
join.

Any ideas? I will be happy to provide more info if required.
Your WHERE clause must be after your join, perhaps? 

SELECT * 
FROM CallDetailRecord
    JOIN CallEvent ON EventID = CallEventID
WHERE StartTime &gt;= 1357102799000 AND StartTime &lt;=1357880399000 


Note: You may want to prefix the fields with table names or aliases...