Scripting

I can't figure out what is going wrong with this rule.  It has worked flawlessly in my IT Service Desk Queue.  Today, I created a new queue for my Legal department.  They also need Department added to the ticket, so I just copied this rule over.  When I try to run it, it errors out and the only thing I can do is delete the rule and start over.  What am I missing?  The ONLY thing I am changing is the 7 to 0, because the Custom Field in the Legal queue is custom field 1

Select Statement:

SELECT HD_TICKET.ID
FROM HD_TICKET
JOIN USER_FIELD_VALUE DEPARTMENT on DEPARTMENT.USER_ID = SUBMITTER_ID and DEPARTMENT.FIELD_ID=2
WHERE HD_TICKET.CUSTOM_FIELD_VALUE7 != DEPARTMENT.FIELD_VALUE

Update SQL:

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