Custom request type query

This custom query in question produces the following columns "requestid", "Subject", "Request Type", "Requester", "Category", "Sub Category", "Created Time", "Completed Time", "Technician", "Priority", "Dueby Time".

I also want a column which also displays "Customer", please you modify the query to include this column.

SELECT wo.workorderid 'RequestID',wo.TITLE 'Subject',rtd.name 'RequestType',aau.FIRST_NAME 'Requester',cd.CATEGORYNAME 'Category',scd.NAME 'Sub Category',dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Created Time',dateadd(s,wo.COMPLETEDTIME/1000,'01-01-1970') 'Completed Time',ti.FIRST_NAME 'Technician',pd.PRIORITYNAME 'Priority',dateadd(s,wo.DUEBYTIME/1000,'01-01-1970') 'Dueby Time' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID left join requesttypedefinition rtd on rtd.requesttypeid=wos.requesttypeid WHERE (wot.THD_WOID=wot.WORKORDERID) and wos.requesttypeid != ''

Please can you help

Thanks. Sylvon