KACE Product Support

I am a newbie when it comes to sql so please bear that in mind here.  With the help of ITNINJA and all of its bloggers I have successfully set up several CTR's to pass information from a parent ticket to a single child ticket.  However, when I introduce more than one child ticket I get errors in the sql select showing multiple ticket ID's and not updating anything in the child tickets.  What am I doing wrong here?  I thought that  if I mirrored the CTR from one child ticket in another child ticket in the same process it would move the same information over.

My scenario is this:  Multiple queue's (which are named departments) that are set up strictly for a new hire process.  A manager will submit a process which is in the HR Queue for the new hire.  I then created child ticket for this in every other department (accounting, IT, marketing and so on).  As I stated before, I got this to work when there was only one child ticket but as soon as a second one is introduced there was no update.

Thanks for your help in advance!

OK here is my select query:

SELECT PARENT.TITLE AS 'Parent Title', HD_TICKET.TITLE AS 'Child Title', HD_TICKET.ID AS 'ID'
FROM HD_TICKET PARENT, HD_TICKET
WHERE PARENT.ID = HD_TICKET.PARENT_ID

and the update query:

UPDATE HD_TICKET PARENT, HD_TICKET
SET HD_TICKET.TITLE = PARENT.TITLE
WHERE ((PARENT.ID = HD_TICKET.PARENT_ID) AND HD_TICKET.ID = <TICKET_IDS>)

This works when there is only ONE child ticket in the process.  when I introduce TWO or more child tickets to a process I get SQL errors.

Please HELP