O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required