A database's primary purpose is to store and help extract information you are looking for. Unlike databases written on a paper sheets, Kexi database allows you to specify more search criteria. Results are returned faster even for large data sets. All this is a power of databases, however to be able to perform effective queries in your database, you need to learn how to tell the database what you are looking for.
With database queries you can limit data coming from a table to a predefined set of rows and columns as well as dynamically join data coming from multiple tables.
Create a new empty query by selecting Query from the toolbar. The design window will appear. The window is split into two areas: query relationships at the top and query columns below.
Select the table
Personsin the drop down list Table: located at the top of the window and click the Insert button. A graphical representation of the table will appear in the relations area. Do the same for the
Phonestable to insert it too.
Add query relationship using mouse drag & drop technique: click the field
personstable, drag it and drop into the
personfield of the
Phonestable. This will join both fields by creating a new relationship.
namefield in the
Personstable, to add the field as a query column. In a similar way, add
cityfields from the
Query design is now ready for testing. Click the Data button on the toolbar, to switch from design to viewing the data provided as query results.
Save the query design for later use by clicking the Save button on the toolbar. Because the query design has not been saved yet, you will be asked to specify a name for it. Enter
Contactstext in the caption field and click the OK button.