How to create a query with external join? In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files... How to create an SQL query to count? This help page explains how to create a count query with the query editor. How to create an SQL query to filter records? This help page explains how to create an SQL query to filter records. How to create an SQL query to get a sum? This help page explains how to create a Sum query with the query editor. How to create an SQL query to get a TOP 10? This help page presents the method for creating an SQL query used to get the first 10 records... How to create an SQL query with a calculation formula? This help page explains how to create a query with a calculation formula with the query editor. How to sort the result of a query? This help page explains how to create a sort query with the query editor.