Hi

I am trying to do an update query in MS Access using SQL

I have two tables Employees and Salaries.

Employees
Emp ID PK
Dept
Postion
SALARY

Salaries
Emp Id PK
HRLY rate
SALARY

I am trying to update the salary figure from the Salaries table into the employee table using sql. How would I do this?

On Oracle I would do:

update employees e
set salary = (select salary from salaries s where s.emp_id = e.emp_id)
where emp_id in (select emp_id from salaries);

The final WHERE clause is to prevent overriding existing salary values with NULL where no matching salaries row exists. Omit the WHERE clause if that is what you would want to do.

No Joy it told me to use an updatable query (which I had done!)

joined update syntax varies from database to database

in sql server, it's whereas in access it's so for your example you would write

Still won't work!

I am being asked to supply a parameter value for employees.salary and then it tells me the table field is not updateable