SQL Query.

For copying content  between 2 tables which have dissimilar columns, I used

INSERT [INTO] tablename1 (field1, field2, field3, field4)

SELECT field1, field2, field3, A_VALUE dummy_field

FROM tablename2

eg:

insert into Jewel_Details(particular,Nos,Grosswt,Netwt,Remarks,Loan_ID,Cus_ID, Cus_Name) 

select particular,Nos,Grosswt,Netwt,Remarks, '1' as Loan_ID, '2' as Cus_ID,'hai' as Cus_Name from temp;