Query data from one table to another

[kiss07]

Hi friends,

I explain detail

I have two table emp and dept, Emp table three columns(name,sa lary,age)
and Dept have two columns( name ,and salary).

In first table Emp have data's in all columns, and Dept(table) have data's only in name,not in salary column.Now i fill the salary column in Dept table from
Emp table Salary column wise.

Anybody help me.

Thanks,
Kiss07

[anuj13singhal]

Hi friends,

I explain detail

I have two table emp and dept, Emp table three columns(name,sa lary,age)
and Dept have two columns( name ,and salary).

In first table Emp have data's in all columns, and Dept(table) have data's only in name,not in salary column.Now i fill the salary column in Dept table from
Emp table Salary column wise.

Anybody help me.

Thanks,
Kiss07

-------------------------------------------------------------------------------------------------------------------

Hi,

Could you please try the query :

insert into dept(salary) as select e.salary from emp e, dept d where e.name=d.name;

hope this works !!

[kiss07]

Dear friend,

Thanku very much..

Kiss07

[MMcCarthy]

Hi friends,

I explain detail

I have two table emp and dept, Emp table three columns(name,sa lary,age)
and Dept have two columns( name ,and salary).

In first table Emp have data's in all columns, and Dept(table) have data's only in name,not in salary column.Now i fill the salary column in Dept table from
Emp table Salary column wise.

Anybody help me.

Thanks,
Kiss07

You should have unique ID Primary keys on both tables. Then you wouldn't need the salary in the Dept table only a reference to the Emp table. Have a look at this tutorial on Normalisation and Table Structures in the Access forum.

Mary