I have Sconnected exact database that I am wanting to sync, everything seems to work except the following:
THIS PART WORKS update SalesTab set ConsignNum = T2.ConsignNum,BrandName = T2.BrandName,+ ItemSize = T2.ItemSize,ItemDate = T2.ItemDate,StyleName = T2.StyleName,descipt = T2.descipt,+ ConComm = T2.ConComm,ItemCost = T2.ItemCost+ from SalesTab T1, tmpItab T2 where T1.ProdNum = T2.ProdNum and T1.ItemDate is null THIS DOES NOT update zSalesTab set ConsignNum = T4.ConsignNum,BrandName = T4.BrandName,+ ItemSize = T4.ItemSize,ItemDate = T4.ItemDate,StyleName = T4.StyleName,descipt = T4.descipt,+ ConComm = T4.ConComm,ItemCost = T4.ItemCost+ from zSalesTab T3, tmpItab T4 where T3.ProdNum = T4.ProdNum and T3.ItemDate is null zSalesTab is sAttached from other database, both tables and databases are identical, just different data What am I doing wrong Tom
