update/append one field to another table

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

Guest

I have a table with following table names:
OrderNo,
Season(Key),
InternalModelCode,
ClientModelCode(Key),
BuyerCode,
SizeCode,
TypeCode,
KindCode,
CompositionCode,
WashCode,
FirstFabric
OrderType
FabricCode

Another Table is with following fields
Season(Key)
ProdOrderNo(Key)
InternalModelCode(Key)
InternalOrderNo
OrderType
QCEmpCodeOP
FabricCode

Now want to update/append only FabricCode from first table to the second
table.

Please help
Bijoy
 
hi,
Update and append queries are two different things.
update changes existing records...
append adds a new record.
Which do you wish? by your wording, i am guessing update.

UPDATE (table2 INNER JOIN table1 ON table1.season(Key) =
table2.season(key) SET table1.fabricCode = [fabricCode];
 
Back
Top