We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
advertisement

Article:
  SQL Subqueries
Subject:   SQL SUBQUERIES
Date:   2003-07-29 15:59:25
From:   anonymous2
Go article, I have a question.
If I have to database that I want to use for update or delete. For example. Database1 has a field/column labeled OREF#. Database2 has a field/column labeled OREF1#. How would I update or delete all the records in database1 where the OREF# equals OREF1# in database2.