how can i solve and how to fix to correct?

[zarlizon91]

This following is my code

SELECT staff.staffid, 
staff.name, 
attendance.checkintime, 
attendance.checkouttime, 
attendance.breakintime, 
attendance.breakouttime, 
attendance.latetime, 
attendance.overtime, 
attendance.transfees, 
COUNT (paidvacation.staffid) AS Leave, 
COUNT(attendance.staffid) AS Work 
FROM attendance 
INNER JOIN staff ON (staff.staffid = attendance.staffid) 
INNER JOIN paidvacation ON (paidvacation.staffid = attendance.staffid) 
WHERE (attendance.createdate>='$startdate' AND attendance.createdate<='$lastdate') GROUP BY attendance.staffid;

ERROR formed

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Leave,
COUNT(attendanc e.staffid) AS Work
FROM attendance
INNER JOIN staff ON ' at line 10

[amnos]

seems to be that you have extra space between

COUNT (paidvacation.staffid) 

count and open braces remove it and check,

SELECT staff.staffid,staff.name,attendance.checkintime,attendance.checkouttime,attendance.breakintime,attendance.breakouttime,
attendance.latetime,attendance.overtime,attendance.transfees,COUNT(paidvacation.staffid) AS Leave,COUNT(attendance.staffid) AS Work
FROM attendance INNER JOIN staff ON (staff.staffid = attendance.staffid) INNER JOIN paidvacation ON (paidvacation.staffid = attendance.staffid)
WHERE (attendance.createdate>='$startdate' AND attendance.createdate<='$lastdate') GROUP BY attendance.staffid;

[Luuk]

the problem is that LEAVE is a reserved word

Because of this it should not be used as an alias, or you should put double quotes around it:

[root@test]> select 1 Leave;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Leave' at line 1
[root@test]> select 1 "Leave";
+-------+
| Leave |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)