NEED HELP WITH SQL STATEMENT

[TNN]

Can anyone please tell me why the following statement will not work. I'm using a access 2000 database.

UPDATE BASSPERS
SET GENDER=(SELECT GENDER FROM BASSPERS1
WHERE EMPNO=1066)

Get error "Operation must use an updateable query."

TNN, Tom
TNPAYROLL@AOL.COM


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[foxdev]

Tom, you might have better luck posting this in the Access forum.

Robert Bradley

http://www.foxdev.com/

 

[TNN]

Thank You Robert,
Will do.
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[dwillisjr]

You need to use an operator that guarantees that only one record will be returned -- even though you specify the employee number, and YOU know it will only return a single record, the database engine does not.

use MAX(Gender), or something like that.