Query component
Lets you run an SQL query on any table, including local .DBF and .DB tables. Query objects enable components to display data from tables on forms and reports.
Set the Query object’s SQL property to an SQL statement that selects a rowset. This links a table to a form or report and populates the Field palette. (If you dragged a table from the Navigator to the design surface, the SQL property is set automatically.)