Miscellaneous

My requirement is to remove the members from the original list when re-presenting the modified list in the child ticket.

Example:

Original List in Parent Ticket:  Adobe, Excel, MineSweeper, Solitaire, WarCraft

In the Parent Ticket the user selected MineSweeper and Warcraft.  The value in the custom_field_value4 capturing this information is recorded as MineSweeper,Warcraft

select custom_field_value4 from HD_TICKET where ID=98

In the Child Ticket I would like for the new list to be presented to EXCLUDE the values that were selected in the Parent ticket, i.e. the NEW list in the Child Ticket should include ONLY Adobe, Excel, Solitaire.

I tried this:

select distinct NAME from ORG1.ASSET where ASSET_TYPE_ID = 10210 and NAME NOT IN (select custom_field_value4 from HD_TICKET where ID=98)

The SQL works fine as long as there is only one item being excluded (i.e. MineSweeper) but when the EXCLUSION contains more than one value *i.e. MineSweeper,Warcraft) then nothing is excluded.