Scripting

I seem to be having trouble finding where the SQL field for department is. If I could find out the name of that (error is on the update query S.CUSTOM_VALUE1) I think the selection and update queries are correct.

I saw the trick where you can get the wizard to tell you names of fields but I cant get it to give me the SQL column names.

Selection:
SELECT HD_TICKET.ID AS ID FROM HD_TICKET
JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID)
WHERE HD_TICKET.SUBMITTER_ID <>0

Update:
UPDATE HD_TICKET T
JOIN USER S ON (S.ID = T.SUBMITTER_ID)
SET T.CUSTOM_FIELD_VALUE0 = S.CUSTOM_VALUE1 WHERE T.ID=<TICKET_IDS>

Error:
07/03/2017 16:42:44> Starting: 07/03/2017 16:42:44 07/03/2017 16:42:44> Executing Select Query... 07/03/2017 16:42:44> selected 1 rows 07/03/2017 16:42:44> Executing Update Query... 07/03/2017 16:42:44> mysqli error: [1054: Unknown column 'S.CUSTOM_FIELD_VALUE1' in 'field list'] in EXECUTE("UPDATE HD_TICKET T JOIN USER S ON (S.ID = T.SUBMITTER_ID) SET T.CUSTOM_FIELD_VALUE0 = S.CUSTOM_FIELD_VALUE1 WHERE T.ID=4968") 07/03/2017 16:42:44> Ending: 07/03/2017 16:42:44

update HD_TICKET as T
    set T.CUSTOM_FIELD_VALUE0 = (select FIELD_VALUE FROM USER_FIELD_VALUE  where USER_ID = SUBMITTER_ID and FIELD_ID = 1) where 
        T.ID = <TICKET_IDS>;