Service request report

Hi there,

I need to run a report from service requests which include additional fields (below)

Column Name

UDF_LONG1

UDF_CHAR1

UDF_CHAR10

UDF_CHAR2

UDF_CHAR3

UDF_CHAR4

UDF_DATE1

UDF_DATE2

UDF_DOUBLE1

UDF_DOUBLE2

UDF_CHAR5

UDF_DOUBLE3

UDF_CHAR6

UDF_DOUBLE4

UDF_DOUBLE5

UDF_CHAR7

UDF_CHAR9

Could someone please help me with the query? I do have service request query, and i have tried to add the above fields, but not working?

SELECT wo.WORKORDERID AS "Request ID",
       wo.TITLE AS "Subject",
       qd.QUEUENAME AS "Group",
       aau.FIRST_NAME AS "Requester",
       ti.FIRST_NAME AS "Technician",
       std.STATUSNAME AS "Request Status",
       sereq.UDF_CHAR1 "Location",
       sereq.UDF_CHAR2 "Floor",
       sereq.UDF_CHAR3 "City" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN ServiceReq_301 sereq ON wo.workorderid=sereq.workorderid
WHERE (wo.ISPARENT='1')