Selecting Tables in an SQL UPDATE Command

To select tables in an SQL UPDATE command using the SQL Wizard:

  1. Run the SQL Wizard and on the Select Operation dialog box, click SQL Update.
  2. Proceed in the SQL Wizard until you reach the Select Table To Update dialog box.
  3. In the Select Table To Update dialog box's Available Tables list, select a table and click Add. Repeat this action for each table required for the SQL statement or, to add all the tables, click All >>.
  4. To re-order the sequence of selected tables, select a table in the Selected Tables list and click the Up or Down arrow to move the table up or down in the list.
  5. Click Next to continue creating the query.

- Or -

Click Back to return to the previous screen in the SQL Wizard.

- Or -

Click Finish if the query is done.

NOTE: To remove a table from the statement, select it from the Selected Tables list and click Remove All to remove all the tables in the statement.

See Also