ITNinja

I found the following SQL statement in a different post, but I need some help tweaking it show that it will display all of the tickets in KACE even if they don't have any work. Can somebody help me get the correct join syntax. Here is the SQL:


select T.ID,
T.TITLE,
T.CUSTOM_FIELD_VALUE0 as Type,
(select FULL_NAME from USER where T.SUBMITTER_ID = USER.ID) as Submitter,
TOTAL_HOURS_WORKED as Total_Hours

from (HD_WORK W, HD_TICKET T, USER U)

JOIN (select T.ID,SUM(
ROUND((time_to_sec(time(stop)) - time_to_sec(time(start)))/3600.0 + ADJUSTMENT_HOURS, 2)) as TOTAL_HOURS_WORKED
from (HD_WORK W, HD_TICKET T, USER U)
where W.HD_TICKET_ID = T.ID
and isnull(W.VOIDED_BY)
and W.USER_ID = U.ID
and W.STOP > DATE_SUB(NOW(), INTERVAL 12 MONTH)
GROUP BY T.ID) TOTAL ON TOTAL.ID=T.ID
where W.HD_TICKET_ID = T.ID
and isnull(W.VOIDED_BY)
and W.USER_ID = U.ID
and W.STOP > DATE_SUB(NOW(), INTERVAL 12 MONTH)
group by T.ID