Contents
- Index
- Previous
- Next
Visual Query Builder
DBQwikEdit's Visual Query builder is a tool that allows you to create queries using a graphical interface. The real power of Visual Query Builder is its ability to generate queries that span multiple tables easily.
You can use Visual Query Builder to generate SQL SELECT Statements.
Add tables to the query by dragging and dropping the tables into the work area. Joint your tables by dragging the column to be joined from one table to the other. Select your column to be included by checking the column name in the work area. You can also include sorts, functions, and grouping by right clicking the columns items.
After running a query, the click the SQL button to bring the SQL into DBQwikEdit's SQL editor, from here you can re run the query and used the more advance export and save functions.