Query WHERE clause and JOIN
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...