<div>
<div class="content wysiwyg-content">
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 ... <br />
<br />
table 1: cases<br />
<br />
id, firmid, inscasenum, aosfiledat, i140filingdate, approvaldate, expdate, 1<br />
<br />
table 2: &nbsp;activities<br />
<br />
caseid, firmid, actdesc, dateinitiated,lastmodified<wbr />,schdemail<wbr />on, complete<br />
<br />
ONLY where cases.InsCaseNum is not null<br />
<br />
How can I do this ?<br />

</div>
</div>


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 ?


Copy data from one table to another

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.