Introduction
In this module, you'll learn how to work with queries in Dynamics 365 Business Central. A query can be used to retrieve data from different tables and combine them in one dataset. Consequently, you will need to link the different tables.
A query translates into efficient SQL queries that are run on the Business Central database. A query can be used to export the data to an XML or CSV file, but it can also be used as a data source for APIs and Power BI reports. This module will also explain how to use the different Query object properties and how to access them in AL code.