Building a Single Query

Top  Previous  Next

Building a single query

 

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.  DWQueryBuilder 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.

 

DWQueryBuilder allows you to build complex SQL queries visually: It will generate virtually any SQL query you will need for your Dreamweaver project. The generated SQL query can be viewed in the SQL Editor.  Advanced SQL programmers can use the SQL editor to further customize SQL or create SQL statements from scratch.

 

Using the DWQueryBuilder is very simple, it does not require any SQL syntax knowledge. You simply add the tables that contain the data you want and DWQueryBuilder will generate the query SQL Statement for you.

 

These topics will guide you on how to use DWQueryBuilder:

 

- Build queries with different join types

- Build queries with sorting, grouping and complex criteria.

- Build queries with different server-specific options.

 

Learn more about:

 

 

When you have finished, you can see the SQL Statement by clicking on the SQL Editor tab.  You can see the data that you have selected  by clicking the Execute button.

 

Note: How to program in SQL is a separate topic. You can find good SQL references on the Internet.

Try A Gentle Introduction to SQL