Fill field in one table from field in another table
Quote:
>01/27/1998
>How can i fill all records in Customer.Name with Invoice.LastName with
>SQL statment ?
>Customer and Invoive are two tables.
>Rami Atia.
Hi Rami,
Assuming that the Customer table has an Invoice number field that will link
it to records in the Invoice table, then try this:
UPDATE Customer INNER JOIN Invoice
ON Customer.InvoiceNum = Invoice.InvoiceNum
SET Customer.Name = Invoice.LastName;
Hope this helps,
Tim "Woof" Gray (remove NOSPAM from email address)
Join us in the Visual Basic and Database Chat every Tuesday 9:30pm EST at:
http://msncomputing.msn.com/forums/default.asp?softwaredevelopment/ch...
or point MS Chat to server "publicchat.msn.com" and meet us in room
"SOFTWARE_DEV_TALKSHOP".
