write a sql query that returns a contact and all the customers they are granted access to on the customer record

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are trying to retrieve a list of contacts and the customers they have been granted access to. You can achieve this by joining the

contact

and

customer

tables in your SQL query. However, please note that the actual field names might differ based on your NetSuite setup. Here is a sample SQL query:

sql
SELECT contact.name, customer.name
FROM contact
JOIN customer ON contact.company = customer.id
WHERE contact.loginAccess = 'Yes'

This query will return a list of contacts and the customers they have access to. The

contact.company

field is assumed to be the link to the

customer.id

. The

contact.loginAccess

field is assumed to be a field that indicates whether a contact has been granted access. Please replace these field names with the actual field names in your NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******