Update stmt with select in the set part

[mveera]

Hi ,

I am having an update statement with the value to be updated is obtained using a select stmt as shown below.

UPDATE employee SET cmpny = (SELECT distinct cmpny FROM company_detail WHERE COUNTRY_NAME = 'Albania')
WHERE COUNTRY_NAME = 'Albania'

When i try to execute the stmt in Access i get the following error

"Operation must use an updateable query"

I am not sure whether Access doesn't support r there is some problem with the stmt.

Thanks
Veera

 

[sunshine19]

I think your SQL statement is your problem (I could be wrong). Normally, the Select part is in the WHERE clause.