G
Guest
I have a query with inner join of two tables that contains the PKs of both
tables and should be updateable. I need to be able to update a memo field in
the query and cannot figure out why it's non-updateable.
Here is my SQL statement:
SELECT t.CodeTextID, t.PartyID, t.CodeID, t.Text1, a.CodeID AS ACodeID,
a.CodeTypeID, a.SortOrder
FROM CodeText AS t INNER JOIN CodeTypeAssociation AS a ON t.CodeID = a.CodeID
WHERE ((a.CodeTypeID)=42);
tables and should be updateable. I need to be able to update a memo field in
the query and cannot figure out why it's non-updateable.
Here is my SQL statement:
SELECT t.CodeTextID, t.PartyID, t.CodeID, t.Text1, a.CodeID AS ACodeID,
a.CodeTypeID, a.SortOrder
FROM CodeText AS t INNER JOIN CodeTypeAssociation AS a ON t.CodeID = a.CodeID
WHERE ((a.CodeTypeID)=42);