Updating records

Results 1 to 2 of 2

Thread: Updating records

  1. #1
    nek Guest

    Default Updating records

    I have 2 databases. One contains the records which are to be updated and the other one is the main database with all records. I want to select records from both databases using a unique key and then update the main database. <BR>Does someone know code of how to do this?<BR>Note that the records are in 2 seperate databases

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating records

    Your going to have to use an INNER JOIN<BR><BR>Do you have access to a Querry Builder? Access? SQL Enterprise Manager or Visual Interdev?<BR><BR>Those will help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts