A query is a new object in Microsoft Dynamics NAV 2013 that you use to specify a set of data from the Microsoft Dynamics NAV database. You can query the database to retrieve fields from a single table or multiple tables. You can specify how to join tables in the query. You can filter the result data. You can specify totalling methods on fields, such as sums and averages.
Posted inDynamics NAV & BC Tips & tricks