hi all,
i have 2 tables , cust_new and details. custname is already inserted to the table cust_new. Now i wants to insert other details to cust_new from table details.
Can anyone please rewrite this SP to get me the result.
SP
insert into cust_new (ADD1,ADD2,ADD3,PINCODE,
TELEPHONE,ABBR,StreetCode,CustCd,WhitePage,EMAILID,website,AREACODE,DistCode,Brcd,MobileNo,USERNAME,ContactPerson,remarks)
Select ADD1,ADD2,ADD3,PINCODE,TELEPHONE,ABBR,StreetCode,CustCd,WhitePage,EMAILID,website,AREACODE,DistCode,Brcd,MobileNo,USERNAME,ContactPerson,remarks
from details where custname = ( select custname from cust_new )