operation must use updateable query ?

[stalk]

I have two rows per patient_Id in table A and one row per patient_id in TableB. both are SQL tables residing on two different servers.
I need to update Table B (Results) with patient details from Table A. When I run select query with distinct key word I can see the details. But when I try to use update query its erroring " Operation must use updatable query".

How to handle this? Table A has a field called Aliquot_ID which is causing duplicate issue. I don't need that info in Table B.

Any thoughts to ignore A;iquot_id and match the records by Patient_id?

Thank you

[ranman256]

1.depending on the query joins, you may get UNUPDATEABLE
2. you cannot run a query with summation on AND update a table. UNUPDATEABLE

3. are both tables writeable? (not set to read only)

is it a simple 2 table join on PatientID? If so, then you shouldnt get the Unupdate err.

[stalk]

TableA is read only, where as tableB is writable. When I run the query in datasheet view I see there are 16 records to update in table B ( 2 records per patient_id) . When I run the update query I get this error.
Only condition I have is TableA.Patient_Id=TableB.Patiet_ID. One other minor difference I noticed is TableA is number ( decimal with precision 20 and TableB is also decimal with precision 18. Is there a way to limit mapping one record( like using distinct or self join etc in update query)