Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
New to NetSuite | SuiteQL Join Type: Full Outer Joins
In the New to NetSuite | SuiteQL Overview article, we explored the fundamental concepts and capabilities of SuiteQL. We continued this in New to NetSuite | SuiteQL: SuiteQL Join Types Overview, where we discussed various join types , including New to NetSuite | SuiteQL Join Type: Outer Joins. In this article, we will focus on one specific Outer Join: Full Outer Joins.
A Full Outer Join combines the results of both a Left Outer Join and a Right Outer Join. This means:
- It returns all rows from the first (left) table.
- It also returns all rows from the second (right) table.
- If rows match based on a common value, they are combined.
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Suitebuilder . RSVP on this event now!
Tagged:
0