Hi frinds,
In my database employee table contains six columns like eno,ename,....., Now i suppose to create one duplicate table for employee instead of all columns i taken 3 columns for duplicate columns like below
select * from employee
select eno,ename,job into employee1 from employee
select * from employee1
Now in duplicate table i added commotion column
alter table employee1 add comm int
Now commotion column contains null values
now i want to add commotion values which are having in base table commotion fields
How any one can tell me ?
thank's
Sandeep.