Summary
In this chapter, you learned about the most important tool for creating or using SQL queries in SAP Business One, Query Manager. This included Query Manager user interface and query display, creation, and save. We also discussed query categories.
You learned the most commonly used query statements such as SELECT, DISTINCT, TOP, and more. You also learned some functions or expressions such as ISNULL(), SUM(), and CASE.
From those statements, functions, and expressions, you have built a good foundation to build your own SQL queries. When you are in doubt about your query building knowledge, it is always advisable to come back here to have a good overview of the statement you need.
In the next chapter, you will have more real world query examples ...
Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
