I have two tables, i need to copy data from one to another, below are the table names and field names, they are in the order in which they should be copied, like cases.id should be copied to activities.caseid, etc ...
table 1: cases
id, firmid, inscasenum, aosfiledat, i140filingdate, approvaldate, expdate, 1
table 2: activities
caseid, firmid, actdesc, dateinitiated,lastmodified,schdemailon, complete
ONLY where cases.InsCaseNum is not null
How can I do this ?