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';

[skhanal]

I am not familiar with MySQL specific syntax but my guess would be you will have to replace the commas with AND in your WHERE clause.


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

[jajawong]

I have solve my problem.
sorry to ask such stupid question!

[penjaga_kubur]

what the meaning deptno.dept=dept.depno