Home Forums SQL Server 7,2000 T-SQL Copy data from one table to another table RE: Copy data from one table to another table

  • May 20, 2008 at 2:06 am

    #817634

    Try this

    insert into empcheck1

    select * from emp

    where emp.empid not in(select empid from empcheck1)

    - Zahran -