Chapter 9. More Complicated SQL Query Topics
This is the last chapter of the book and we will have an extended discussion, which will give you some of the most complicated examples of SQL query in SAP Business One. This chapter will bring you closer to introducing even more Business Intelligence into SAP Business One. The main topics include:
- The Case expression usage
- Working with subquery
- Using PIVOT to simplify a cross tab style queries
- Database query for Excel
In addition, this last section will give you some advice on the pitfalls and mistakes to be avoided in query writing.
These topics are more suitable to the users who have extra interests to extend their capabilities to create more complicated queries. Although the previous examples can be revisited, ...