RE: SuiteQL Built-in Country Table Join
I have created a custom record in NetSuite with one of its fields referencing the built-in “Country” record. The issue I am running into is the following SQL query is giving me the “Search error occurred: Invalid or unsupported search” error:
SELECT * FROM customrecord_new_record nr
INNER JOIN COUNTRY c ON c.id = nr.custrecord_country
Any thoughts on this? I am able to query the “Country” table by itself
Nevermind, I needed to use c.uniquekey not c.id