<div>
INsert table2<br />
Select * <br />
from table1 as one left outer join table2 as two<br />
on one.id = two.id<br />
where two.id is null
</div>


INsert table2
Select *
from table1 as one left outer join table2 as two
on one.id = two.id
where two.id is null

<div>
u can use DTS to trnsfer the data, which will be very useful and gives knowledge in DTS
</div>


u can use DTS to trnsfer the data, which will be very useful and gives knowledge in DTS

<div>
You can do this with or without DTS. &nbsp;Its not really needed.
</div>


You can do this with or without DTS.  Its not really needed.

<div>
Using DaveSlash example, <br />
<br />
insert into employee2<br />
select * from employee<br />
minus<br />
select * from employee2;<br />

</div>


Using DaveSlash example,

insert into employee2
select * from employee
minus
select * from employee2;


<div>
<br />
insert into employee2<br />
select * from employee<br />
minus<br />
select * from employee2;<br />
<br />
<br />
That won't work if this is SQL Server...not sure what platform this is.....MINUS does not exist in T-SQL
</div>



insert into employee2
select * from employee
minus
select * from employee2;


That won't work if this is SQL Server...not sure what platform this is.....MINUS does not exist in T-SQL

<div>
<div class="content wysiwyg-content">
I am copying data from table1 to create table2. I would like to create table2, do testing then append current data from table1 into table2.<br />
<br />
Can anyone help me write a query that takes all data from table1 that is not in table2 and inserts the data in table2?<br />
<br />
Thanks,<br />

</div>
</div>


I am copying data from table1 to create table2. I would like to create table2, do testing then append current data from table1 into table2.

Can anyone help me write a query that takes all data from table1 that is not in table2 and inserts the data in table2?

Thanks,


copy table1 and create table2, query table1 for changes and add them to table2

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.