This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```SELECT 
    j.internalid AS JobID,
    j.entityid AS JobName,
    j.parent AS CustomerID,
    c.companyname AS CustomerName,
    j.status AS JobStatus
FROM 
    Job j 
LEFT JOIN 
    Customer c ON j.parent = c.ID```

```SELECT 
    j.id AS JobID,
    j.entityid AS JobName,
    j.parent AS CustomerID,
    c.companyname AS CustomerName,
    j.entitystatus AS JobStatus
FROM 
    Job j 
LEFT JOIN 
    Customer c ON j.parent = c.ID```

Just change "internalid" to id
and 'status' to entitystatus

It says. Search error occurred: Record 'job' was not found.

thats strange. If you run this in the console does it say the same thing

```let queryString = `SELECT 
    j.id AS JobID,
    j.entityid AS JobName,
    j.parent AS CustomerID,
    c.companyname AS CustomerName,
    j.entitystatus AS JobStatus
FROM 
    Job j 
LEFT JOIN 
    Customer c ON j.parent = c.ID`;
let query = require(['N/query']); query = require('N/query'); 
let queryResults = query
        .runSuiteQL({ query: queryString })
        .asMappedResults();
console.log(queryResults);```