update/append one field to another table

[Bijoy George]

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

 

[Guest]

see your last post