Does anone know the map table that joins promotionCode record with the multi select customer field on it? This is a basic query that gives list of all the customers tagged in the promotion record. I want to see each custromer in a seprate row, NS creates a mapping table where we have mapone and maptwo which we can use for all the mutli select fields, but for this standard field I am unable to find it.

SELECT
    p.customers as customers
FROM
    promotionCode AS p
WHERE
    p.id = '256'

From analytical dataset I found asbout this table

promotionCodeEntityMap

But it doesn't seem to exist.

I'm not familiar with this table.. is the

customers

a standard or custom field? I ask because I don't see it on my sandbox environment

standard field you need to enable a feature under setup > company > enable features > transaction tab called Promotion Codes. Only then the record and field will appear for you I think.

Ah I see, I'll try to poke around later if I can set some time aside

Thank you appreciate it, I did figure out a workaround though, but would prefer to know the actual table if there is one.