Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: How to Collete a database?

    How to Collete a database? What is the code? Using sql.


    I had have two database, and the two database have two table which are similiar same but the data are some different. It mean, the two table should have the same data, but there are miss another one. How to make the data same to each other in the two table?


  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    depends on your database platform. In general, you can use a left or right join in an update statement, then set your field value from one table equal to the field value in your other table if the first table is null.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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