Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Simple Update sql

    I have 2 tables they are exactly the same, I want to set the Fillcontacts id = the contacts id. (this is the only data missing) The Invid will be the same in each table and the phone also.

    When i try my sql in access i am propted for Contacts.Idcont as if it were a paramater.

    UPDATE FillContacts SET FillContacts.idCont =Contacts.idcont
    WHERE (((FillContacts.InvId)=Contacts.invid) AND ((;

    btw why doesnt this work in acces when it would in sql serv?

  2. #2
    Join Date
    Feb 2004
    You might try:
    UPDATE FillContacts INNER JOIN Contacts
    ON FillContacts.InvId = Contacts.invid
    AND =
    SET FillContacts.idCont = Contacts.idcont;

Posting Permissions

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