I am running the below query, but the last two columns do not display with the title Subcategory and Item. Also, the item category is not displaying the correct description, it is displaying the Subcategory description. After the query is a screen shot of the results when running the query in ServiceDesk, the second screenshot is the correct data when running the query in SSMS.

SELECT   WorkOrder.WORKORDERID

,SDUser.FIRSTNAME

,SDUser.LASTNAME

,WorkOrder.TITLE

,workorder.DESCRIPTION

,RequestResolution.RESOLUTION

,catDef.CATEGORYNAME

,subDef.NAME AS 'Subcategory'

,itemDef.NAME AS 'Item'

FROM WorkOrder

LEFT JOIN SDUser ON WorkOrder.REQUESTERID = SDUser.USERID

RIGHT JOIN RequestResolution ON WorkOrder.WORKORDERID = RequestResolution.REQUESTID

FULL OUTER JOIN WorkOrderStates woStates ON WorkOrder.WORKORDERID = woStates.WORKORDERID

LEFT JOIN CategoryDefinition catDef ON catDef.CATEGORYID = woStates.CATEGORYID

LEFT JOIN SubCategoryDefinition subDef ON subDef.SUBCATEGORYID = woStates.SUBCATEGORYID

LEFT JOIN ItemDefinition itemDef ON itemDef.ITEMID = woStates.ITEMID

WHERE WorkOrder.SITEID = 301 AND WorkOrder.CREATEDTIME >= 1546318800000 AND itemDef.NAME = 'Outlook'

ORDER BY WorkOrder.WORKORDERID