Coffeehouse Thread

2 posts

Need Update query Using SQL.

Back to Forum: Coffeehouse
  • 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.

     

  • User profile image
    ScanIAm

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.