Results 1 to 2 of 2

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

  1. #1
    Join Date
    Feb 2003
    Posts
    4

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

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

  2. #2
    Join Date
    Feb 2003
    Posts
    4
    I have solved my problem.
    sorry to ask such stupid question!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •