update ar_tradevv.dbo.mainProductType set ar_tradevv.dbo.mainProductType.typename=testdb.dbo.a.ar from ar_tradevv.dbo.mainProductType,testdb.dbo.a where ar_tradevv.dbo.mainProductType.tid= testdb.dbo.a.id
