ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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.