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, ...

Get Mastering SQL Queries for SAP Business One now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.