The Visual Query Builder
If you want to create a page that displays data that is from several related tables, or contains only a subset of the records in a table, you can do this using SQL Queries. dbQwikSite contains a built in visual SQL query builder to allow you to design queries visually. You do not need any SQL knowledge to create queries this way.
The visual query is available from several dialogs in dbQwikSite. Usually anywhere you can select a table, your can also build a query using the visual query builder. For accessing the Visual Query Builder for your Page Group Dataset, follow these steps.
1. Double Click your Page group dataset.
2. The Dataset Items Editor will appear, Click the Redefine Dataset Button.
3. Select "Load data from query" and Click the "Visual Query Builder" button