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

aaron2181 Rookie Asked on May 28, 2025 in SuiteTalk.
Add Comment
1 Answers

Nevermind, I needed to use c.uniquekey not c.id

Rookie Answered on May 28, 2025.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.