Complex Table References

Contact Us or call 1-877-932-8228
Complex Table References

Complex Table References

  • Simple DDL statements will require basic criteria to be specified in the WHERE clause.
  • More complex processing can include updates that use correlated subqueries or the use of an IN clause.
  • To determine the effects of DML statements that change existing data, you can first construct a query that returns the rows that you intend to act upon.

DML statements that specify criteria in the WHERE clause are simple to construct. However, more complex processing is possible including updates that use correlated subqueries or the use of an IN clause.

To determine the effects of DML statements that change existing data, you can first construct a query that returns the rows that you intend to act upon. You can also verify your changes and roll them back rather than committing them if the changes made did not meet your intentions.

Next