The WHERE Clause servers two different purposes. One is to limit the records
affected by a DML statement. The second to join two or more tables, view, or materialized views for DML.
The following links all have demonstrations of using the WHERE clause ... each in a different context.
|