Coffeehouse Post

Single Post Permalink

View Thread: Need Update query Using SQL.
  • User profile image
    Eigenvector

    Hi All,

    I want to update Consultant table fields by entering data into Invoice.

    In Consultant table I want to update " First Name, Last Name, Description " from Invoice table.. I have defined ConsultantID as Primary Key in Consultant Table.

    We entre data into Invoice table Like First Name, Last Name, Description etc, I want to update only " First Name, Last Name, Description" in Consultant table by running simple update query.

    For Invoice table I have Primary Key is InvoiceID.

    Can some please write a simple SQL query for me. I need this for MS Access.

    Regards

    Eigen Vectors.