Joins and Data order

The Edit query dialog allows you to specify the joins between the tables in a record used for a form, report, or service. Joins between tables referenced in the form are set up in the query property of the business record.

Figure: Edit query dialog


This figure is a screenshot of the Edit query dialog. See the surrounding text for more information about using the Edit query dialog to create a new form for a generated application.
Join
If two tables will be involved in the query, this section is enabled to enter an SQL Join condition for the SQL Query.
Additional tables
Add a table here that does not have any fields in the record. For example, list the orders table here if the orders table is required to enable the join between the customer and items tables.
Where
Add additional conditions to the SQL Where clause, to restrict the rows returned by the SQL Query to a subset of the data.
Order by
Change the default order in which the SQL Query will return the rows.