Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    126

    Angry Unanswered: help with update query!

    I have two tables... BillD and NewBillD

    BillD has columns [order number], [price], [cost] etc.

    NewBillD has just columns [order number], [price]

    the order numbers in both tables are the same. I want to update billd with price from NewBillD.

    Why will this query not work:

    Update billd
    set price = newbilld.price
    where account = newbilld.account


    Thanks!

    Ken

  2. #2
    Join Date
    Jan 2003
    Posts
    126

    Fixed it...

    duh, forgot to join.... Is it Friday yet?

Posting Permissions

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