Need help with data arrays

From your two subqueries, I think you only need the SUM() fields, a.total_absence and s.total_sickness.

I've tried leaving out the events.eventid in the subquery select but that throws the following error:

Code:

Error Number: 1054
Unknown column 'events.staffid' in 'on clause'

so it seems to need the fields explicitly selected so it can do the join maybe? It's no big deal though, I can live with having the extra data in the result set.

Oh, sorry, I wasn't clear. You do need to specify the fields in each subquery's SELECT. However, you don't have to include them in the main SELECT, the one that is now currently SELECT *. Replace SELECT * with just the list of fields you want, which are whatever fields you need from the staff table plus the one total field from each subquery, and you'll get a clean result, with no extra fields.

As for COALESCE(), that was just my fat finger.   Glad you were able to use it regardless.

See you around! 

Hey, don't work without a PHP debugger. Several free IDEs have this features built in. Two are NetBeans and CodeLobster. Without a debugger, it's like you're driving with a blindfold on -- you are going to crash!