0

I got error of sql syntax in Mysql. Where am I wrong? My query is,

SELECT *
FROM `fx_users_attendance`
   LEFT OUTER JOIN `fx_account_details` ON fx_account_details.user_id = fx_users_attendance.user_id
   LEFT OUTER JOIN `fx_departments` ON fx_departments.deptid = fx_account_details.department
   LEFT OUTER JOIN `fx_users` ON fx_users.id = fx_users_attendance.user_id
WHERE fx_departments.deptid IN("1")
      AND fx_users.id ="5"
      AND date(fx_users_attendance.clock_in) BETWEEN (date(fx_users_attendance.clock_in) >= "2015-10-20"
      AND date(fx_users_attendance.clock_in) <= "2015-11-10")
Improve this question
1
  • Can you post the error you get? Commented Nov 20, 2015 at 11:57

1 Answer 1

Reset to default
1

You miss understood the syntax of BETWEEN

date(fx_users_attendance.clock_in) BETWEEN (date(fx_users_attendance.clock_in) >= "2015-10-20" AND date(fx_users_attendance.clock_in) <= "2015-11-10")

Should be changed to

date(fx_users_attendance.clock_in) BETWEEN '2015-10-20' AND '2015-11-10'

SELECT * 
FROM `fx_users_attendance`
 LEFT OUTER JOIN `fx_account_details` ON fx_account_details.user_id = fx_users_attendance.user_id 
 LEFT OUTER JOIN `fx_departments` ON fx_departments.deptid = fx_account_details.department 
 LEFT OUTER JOIN `fx_users` ON fx_users.id = fx_users_attendance.user_id 
 WHERE fx_departments.deptid IN("1") AND fx_users.id ="5" AND date(fx_users_attendance.clock_in) BETWEEN '2015-10-20' AND '2015-11-10'

Hope this helps.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.