SuiteQL Join to a Multi-Select Field

Question

I'm trying to write a SuiteQl statement that will join my item table to a custom record that has a multi-select field including the item id.

select item.id from item JOIN CUSTOMRECORD_REBATE_AGREEMENT_DETAIL cr on cr.custrecord_rebate_items_included = item.id

Answer 1

Figured it out. Referenced this answer

select
item.id, map.*, BUILTIN.DF(mapone), BUILTIN.DF(maptwo), BUILTIN.DF(custrecord_tier_group), custrecord_rip_code
     FROM
item
        JOIN
           map_CUSTOMRECORD_REBATE_AGREEMENT_DETAIL_custrecord_rebate_items_included map
           ON map.mapone = item.id 
JOIN CUSTOMRECORD_REBATE_AGREEMENT_DETAIL cr on cr.id = map.mapone
JOIN customrecord_rebate_agreement ca on cr.custrecord_rebate_parent  = ca.id