SQL Select/Insert help!!!

[Goomba79]

Hello!

I am pretty new to SQL so I imagine my problem is extremely simple!

What I am trying to do is select values in the columns Fname and Sname and insert them in to the column Uname Where the selected empNo emp = empno.
i'm hoping this will run through every entry in my table.

my query so for looks like this...

Select SRuser.Fname, SRuser.Sname As Myname, SRUser.EmpNo as Emp
Insert Myname Into SRuser (Uname)
Where EmpNo = Emp;

If anyone could give me any pointers to how to do this I would greatly appreciate it!

Thanks in advance,

Iain

 

[dhookom]

Apparently you want to create an Update query.

UPDATE [YourTableNameHere]
SET [YourFieldNameHere] = [Some Expression Here]
WHERE [AnotherFieldHere] = [Another Expression Here]

Consider using the query designer interface to build queries until you are more familiar with the syntax.

Duane
Hook'D on Access
MS Access MVP

 

[simian336]

Is this 2 different tables or one table.

Simi

 

[Goomba79]

Hello,
yeah it was an update statement that i needed!
It's the same table that i am taking the data from and putting it into

 

[dhookom]

I should have also questioned why you need to store a value that can easily be calculated. Typically this is not good practice.

Duane
Hook'D on Access
MS Access MVP

 

[Goomba79]

i cut and pasted all the employee names from excell into my table, Fname and Sname i wanted their full name to be their username Uname