Well this is what I got... comments?


INSERT INTO orcfocus (vnd_id,name1,name2,vndnbr,eff_dt,vnd_typcd,affiliate,lst_updt_d,addr1,primpyadr,addr2,city,state,zip,country,addr_type,addr3,addr4,inact_dt,phone,bank_nbr,email,fax,pay_type,terms_id) ;

SELECT t1.vnd_id,t1.vnd_name,t1.vnd_nm_alt,t1.segment1,t1.attrib8,t1.vnd_Typcd,t1.attrib1,t1.lastupddt,t2.vnd_id,t2.addr1,t2.primpysite,t2.addr1,t2.city,t2.state,t2.zip,t2.country,t2.attrib1,t2.addr3,t2.addr4,t2.inactdt,t2.areacode+phone,t2.banknbr,t2.emailaddr,t2.faxareacod+fax,t2.pmt_methcd,t2.terms_id ;

from povnst1 t1 join povnda1 t2 on t1.vnd_id = t2.vnd_id WHERE t1.vnd_id => '1'