How to: Join Data Items to Define the Query Dataset in Microsoft Dynamics 365 Business Central

Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset.

Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset.

Source : Divyesh Chitte
Read more…