Mastering SQL Queries for SAP Business One

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