I am running an items query, on these items there are custom fields (multiselect) linked to customlist. when I select the customfields then only the IDs are sent All my tries to link/join with the customlist have failed. I am able to read the data from the customlist table Have you any idea on how join the customList table to the items table?

SELECT

item.id

,item.custitem_product_tags

, tagList.*

FROM

item as item

,customlist_product_tags_list as tagList

WHERE

/*AND item.custitem_product_tags IN (SELECT id FROM customlist_product_tags_list)*/

/*AND item.custitem_product_tags IN (2)*/

/*AND CONTAINS(item.custitem_product_tags, '2', 1) > 0*/

/*AND tagList.recordid = to_number( item.custitem_product_tags, '99999')*/

/*AND tagList.recordid = 2*/

ORDER BY

item.lastmodifieddate DESC

FETCH FIRST 10 ROWS ONLY

Have you ever successfully utilized mapping tables for multiple select queries? https://blog.prolecto.com/2021/08/21/learn-how-to-sql-query-netsuite-multiple-select-fields/