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

M

mix

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
 
J

John Spencer (MVP)

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>
 
Top