Thanks, @alien4u and @NElliott. I appreciate the help... I think this is the first time that I've tried to join directly to a related custom record. I thought I was missing something, but apparently not.

Have you tried building the search in the UI and once you get your desired search results, export it using the NetSuite Export Search Chrome plugin?