After updating mysql from 4 to 5, I'm now getting this error:
Invalid SQL: SELECT HRS.Hrs AS Val, HRS.Job_ID, TS.Staff_ID, Staff.First_name, Staff.Last_name FROM Timesheets AS TS, Timesheet_hrs AS HRS LEFT OUTER JOIN Staff ON (TS.Staff_ID=Staff.ID) WHERE TS.ID=HRS.Timesheet_ID ORDER BY Staff.First_name, Staff.Last_name, HRS.Job_ID DESC: 1054 (Unknown column 'TS.Staff_ID' in 'on clause')
1054 is a known issue:
I've tried wrapping the FROM conditions in brackets, but it doesn't fix the problem entirely.
Since I'm a mysql noob, would anyone be kind enough to help translate the SELECT line into a working mysql5 command?
I'll update this as soon as I have a working fix