• If you dont want to insert data in Field3 then you can remove it...

    OR

    you can defined DEFAULT value for Field3 so that you will not get error while inserting data from table1 to table2

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/