How do i append in one record instead of the whole table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wanna put customer name from customer table into customer name in a order
table by using the customer id on the order table. I can only get all records
to be updated and not just one. Im using append
 
First problem is one of syntax.

APPEND = Add Record(s)
UPDATE = Change EXISTING record(s)

So what do you want to do. It sounds as if you want to update the order table.
Normally putting the same data into two tables is not a good idea.

UPDATE OrderTable INNER JOIN CustomerTable
ON OrderTable.CustomerID = CustomerTable.CustomerID
SET Order.CustomerName = CustomerTable.CustomerName
WHERE OrderTable.OrderID = <INSERT Primary Key Value here>
 
Back
Top