How do you suiteql right and left joins work when there are nulls in the data

AI generated answer (using internal Slack threads):

In SuiteQL, the LEFT JOIN and RIGHT JOIN operations work similarly to how they do in standard SQL. They are used to combine rows from two or more tables, based on a related column between them. When there are NULL values in the data, the behavior of these joins is as follows: - A LEFT JOIN returns all the records from the left table, and the matched records from the right table. If there is no match, the result is NULL on the right side. - A RIGHT JOIN returns all the records from the right table, and the matched records from the left table. If there is no match, the result is NULL on the left side. Here is an example of a LEFT JOIN in SuiteQL:

sql
SELECT contact.id, contact.firstname, contact.lastname, customer.id, customer.companyname
FROM contact
JOIN customercompanycontact ON contact.id = customercompanycontact.contact
JOIN customer ON customer.id = customercompanycontact.contactscompany
WHERE contact.id = 16357

In this example, the query is joining the

contact

,

customercompanycontact

, and

customer

tables. If there is a

contact

that does not have a corresponding

customercompanycontact

or

customer

, the fields for those tables will be NULL in the result set. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******