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';
Printable View
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';
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';
I have solve my problem.
sorry to ask such stupid question!
what the meaning deptno.dept=dept.depno