Use SQL Assist to create SQL statements. With SQL Assist and some knowledge of SQL, you can create SELECT, INSERT, UPDATE, and DELETE statements.
SQL Assist uses a notebook to help you organize the information that you need to create an SQL statement. You can go from page to page by clicking on the tabs. You can move through the pages in any order; however, selections that you make on one page might change or limit selections that you can make on another page.
Some pages require that you make selections on other pages. For example, you must select one or more tables on the Tables page before you can define conditions on the Conditions page.
Depending on the application that you were using when you entered SQL Assist, some pages and controls might not be available.
Tasks