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

Avoiding pitfalls while building queries

There are many pitfalls when you begin to create new queries. You can find some of them by yourself. It would be better if you can avoid them before your start.

Here is a useful list of pitfalls I found that should be avoided:

  • Starting to create a query before knowing the data table structure you are querying
  • Creating a complicated logic inside your SQL query and not simplifying it
  • Trying to do too many things in one query
  • Relying solely on others' help and not doing trial runs on your own

These topics are discussed one by one.

Creating a query before knowing the data table structure

One of the most common problems for query writing is related to data structure. A new query learner tends to start building the ...

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