Coffeehouse Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

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

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.