what's wrong with my SQL Statement(MySQL)????

[jajawong]

select * from StaffDetail, Division, Dept where StaffID in ('1','2'), StaffDetail.DivID = Division.DivID,StaffDetail.DeptID = Dept.DeptID,JoinDate>=' 2000-01-01' and JoinDate<=' 2000-01-02';