insert into newdb..pm00200 (VENDORID, VENDNAME, VNDCHKNM, VENDSHNM, VADDCDPR, VADCDPAD, VADCDSFR, VADCDTRO, VNDCLSID, VNDCNTCT, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE, COUNTRY, PHNUMBR1, PHNUMBR2, PHONE3, FAXNUMBR, UPSZONE, SHIPMTHD, TAXSCHID, ACNMVNDR, TXIDNMBR, VENDSTTS, CURNCYID, TXRGNNUM, PARVENID, TRDDISCT, TEN99TYPE, TEN99BOXNUMBER, MINORDER, PYMTRMID, MINPYTYP, MINPYPCT, MINPYDLR, MXIAFVND, MAXINDLR, COMMENT1, COMMENT2, USERDEF1, USERDEF2, CRLMTDLR, PYMNTPRI, KPCALHST, KGLDSTHS, KPERHIST, KPTRXHST, HOLD, PTCSHACF, CREDTLMT, WRITEOFF, MXWOFAMT, SBPPSDED, PPSTAXRT, DXVARNUM, CRTCOMDT, CRTEXPDT, RTOBUTKN, XPDTOBLG, PRSPAYEE, PMAPINDX, PMCSHIDX, PMDAVIDX, PMDTKIDX, PMFINIDX, PMMSCHIX, PMFRTIDX, PMTAXIDX, PMWRTIDX, PMPRCHIX, PMRTNGIX, PMTDSCIX, ACPURIDX, PURPVIDX, NOTEINDX, CHEKBKID, MODIFDT, CREATDDT, RATETPID, Revalue_Vendor, Post_Results_To, FREEONBOARD, GOVCRPID, GOVINDID, DISGRPER, DUEGRPER, DOCFMTID, TaxInvRecvd, USERLANG, WithholdingType, WithholdingFormType, WithholdingEntityType, TaxFileNumMode, BRTHDATE, LaborPmtType, CCode, DECLID, CBVAT, Workflow_Approval_Status, Workflow_Priority, Workflow_Status, VADCD1099, DEX_ROW_TS)
select v.VENDORID, v.VENDNAME, v.VNDCHKNM, v.VENDSHNM, v.VADDCDPR, v.VADCDPAD, v.VADCDSFR, v.VADCDTRO, v.VNDCLSID, v.VNDCNTCT, v.ADDRESS1, v.ADDRESS2, v.ADDRESS3, v.CITY, v.STATE, v.ZIPCODE, v.COUNTRY, v.PHNUMBR1, v.PHNUMBR2, v.PHONE3, v.FAXNUMBR, v.UPSZONE, v.SHIPMTHD, v.TAXSCHID, v.ACNMVNDR, v.TXIDNMBR, v.VENDSTTS, v.CURNCYID, v.TXRGNNUM, v.PARVENID, v.TRDDISCT, v.TEN99TYPE, v.TEN99BOXNUMBER, v.MINORDER, v.PYMTRMID, v.MINPYTYP, v.MINPYPCT, v.MINPYDLR, v.MXIAFVND, v.MAXINDLR, v.COMMENT1, v.COMMENT2, v.USERDEF1, v.USERDEF2, v.CRLMTDLR, v.PYMNTPRI, v.KPCALHST, v.KGLDSTHS, v.KPERHIST, v.KPTRXHST, v.HOLD, v.PTCSHACF, v.CREDTLMT, v.WRITEOFF, v.MXWOFAMT, v.SBPPSDED, v.PPSTAXRT, v.DXVARNUM, v.CRTCOMDT, v.CRTEXPDT, v.RTOBUTKN, v.XPDTOBLG, v.PRSPAYEE, v.PMAPINDX, v.PMCSHIDX, v.PMDAVIDX, v.PMDTKIDX, v.PMFINIDX, v.PMMSCHIX, v.PMFRTIDX, v.PMTAXIDX, v.PMWRTIDX, v.PMPRCHIX, v.PMRTNGIX, v.PMTDSCIX, v.ACPURIDX, v.PURPVIDX, v.NOTEINDX, v.CHEKBKID, v.MODIFDT, v.CREATDDT, v.RATETPID, v.Revalue_Vendor, v.Post_Results_To, v.FREEONBOARD, v.GOVCRPID, v.GOVINDID, v.DISGRPER, v.DUEGRPER, v.DOCFMTID, v.TaxInvRecvd, v.USERLANG, v.WithholdingType, v.WithholdingFormType, v.WithholdingEntityType, v.TaxFileNumMode, v.BRTHDATE, v.LaborPmtType, v.CCode, v.DECLID, v.CBVAT, v.Workflow_Approval_Status, v.Workflow_Priority, v.Workflow_Status, v.VADCD1099, v.DEX_ROW_TS
from olddb..pm00200 v
left join newdb..pm00200 v2 on v2.vendorid = v.vendorid
where v2.vendorid is null