UPDATE SQL problem..
I am trying to update field F1 in table T1 with the results from a
summation query Q1. Q1 is most definitely not updateable. The update is
simply a join from T1 to Q1 on the primary key with only F1 in the
Access97 tells me the query must be updatable. Left-Joining T1 to Q1
does not help. I normally simply wrap this in a trx in code, but am
curious how to beat this seemingly simple operation.
SQL (noting that the query Q1 is non-updatable):
LEFT JOIN Q1
ON T1.PK = Q1.FK
T1.F1 = IIf([Q1.F2=0,True,False);
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center