Removing conditions from SQL statements in the SQL Query Builder
After you define conditions for a SELECT, UPDATE, or DELETE statement, you can remove a condition in the SQL Query Builder.
Procedure
To remove a condition from an SQL statement in the SQL Query Builder:
- Open the statement in the SQL Query Builder.
- On the Conditions page in the Design pane, right-click the row that contains the condition and then click Remove Condition on the pop-up menu.