SQL Wizard

The SQL Wizard in GoAnywhere allows you to quickly build SQL Select statements using intuitive screens.  You would first choose the database server to connect to, and then you can drill-down and select the schemas (libraries), tables (files) and columns (fields).  You can additionally specify the column headings, WHERE, JOIN and ORDER BY criteria on the remaining screen tabs.

 

A preview of the SQL Select statement is shown on the bottom of the screen as you advance through the tabs in the wizard.  When finished, the generated SQL Select statement will be inserted within the Project.

 

Screen example of the SQL Wizard: