Dear All
I have a master table with data. after two months I need to insert three new colums in this table. I inserted. The table has 1500 records. I inserted data of new colums in another table. both tables have same uniue field of 'EMP NO'. Now how I enter this data in to my master table? either run an update query or append query or some thing new.
Thanks.
Wasim