If you want to get the sum of all charges on a ticket, you can do this:
SELECT tickets.subject, TIME_FORMAT(SEC_TO_TIME(SUM(tickets.charges.charge_time)), '%Hh %im') AS 'Charge Time'
FROM tickets
GROUP BY tickets.id AS 'ID'
If you want to get the sum of all charges on a ticket, you can do this:
SELECT tickets.subject, TIME_FORMAT(SEC_TO_TIME(SUM(tickets.charges.charge_time)), '%Hh %im') AS 'Charge Time'
FROM tickets
GROUP BY tickets.id AS 'ID'
Dodaj komentar
Pred objavo komentarja se moraš prijaviti.