|
  
|
||
|
|
||
Open the Query/Reports form.
This activates the query builder.
Because ExSync empowers the user to connect to more than one data source and destination. The Query builder is not active by default. You must select a connection to a valid Microsoft SQL server before activating the query builder.
The visual query builder form allows drag and drop, point and click creation of SQL queries. Standard and Microsoft specific SQL syntax can be typed in also.
A visual query builder that allows you to build complex SQL queries via an intuitive visual query building interface.
To work with with the query builder, you need basic knowledge of SQL concepts. The query builder will help you to write correct SQL code hiding technical details.
| • | Build queries with different join types |
| • | Build queries with sorting, grouping and complex criteria. |
| • | Build queries with different server-specific options. |
