Suite Codex

SuiteQL

SuiteScript SuiteQL Joins

Using SuiteQL Joins

SuiteScript SuiteQL joins combine records like transaction and item.

Introduction to SuiteQL Joins

In SuiteScript, SuiteQL joins allow developers to efficiently combine data from multiple record types, such as transactions and items. Understanding how to properly use joins in SuiteQL can enhance data queries by providing comprehensive insights from related records.

Types of Joins in SuiteQL

SuiteQL supports several types of joins, including:

  • INNER JOIN: Returns records with matching values in both tables.
  • LEFT JOIN: Returns all records from the left table and matched records from the right table. Unmatched records from the right table will result in NULLs.
  • RIGHT JOIN: Returns all records from the right table and matched records from the left table. Unmatched records from the left table will result in NULLs.

Using INNER JOIN in SuiteQL

An INNER JOIN in SuiteQL allows you to retrieve records that have matching values in both tables. For example, you can join transactions with items to get details of items sold in each transaction.

Using LEFT JOIN in SuiteQL

A LEFT JOIN retrieves all records from the left table and matched records from the right table. This is useful when you want to include all transactions whether or not they have corresponding item records.

Using RIGHT JOIN in SuiteQL

Similarly, a RIGHT JOIN retrieves all records from the right table and matched records from the left table. This can be useful when focusing on all items, whether or not they have been sold in any transaction.

Conclusion

Understanding and using joins in SuiteQL allows you to efficiently query and combine related records in SuiteScript. Mastery of INNER JOIN, LEFT JOIN, and RIGHT JOIN will enable you to create more complex and insightful data queries, enhancing the capabilities of your SuiteScript applications.

SuiteQL

Next
SuiteQL Filters