Hello everyone, I have been using SuiteQL for a couple of months, but mostly for strait queries or simple joins. I finally need something a bit more complicated. The SuiteQL Tables Reference, join section has a join that I need to make, but the join pairs is described as "CUSTOMRECORD_URLS.id = MAP_customrecord_urls_custrecord_license_no_urls.mapone MAP_customrecord_urls_custrecord_license_no_urls.maptwo = CUSTOMRECORD_LICENSE.id" where do I get the MAP_... join table?

Are you trying to join a multi select field ?

I do not know. I do know that it is many to many relationship.

What do you mean by “where do I ‘get’ the map table” ? It’s in the database same as all the other tables.

Thanks! I thought that the MAP... tables would be in the table list, but they are not

some tables are missing

Map table is something netsuite creates for multi select fields. You should read more about it in Tim's blog.