|
The SQL Wizard is an excellent tool for quickly creating SQL SELECT statements without having to know the SQL syntax. Just select the files, fields and criteria and then click a button to generate the statement.
 Demonstrates the criteria portion of the SQL Wizard
Details:
 |
Launch wizard from within the SQL editor |
 |
Select one or more files |
 |
Select one or more fields from those files |
 |
Enter WHERE criteria for selecting just certain records |
 |
Enter ORDER BY criteria for changing the sorting of the records |
 |
Optionally override the column headings |
 |
Inserts generated SELECT statement into the SQL editor |
 |
Statement can then be ran immediately or saved for later execution |
|