"Operation Must use a updatable query" message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to run:

UPDATE tblActivityQuestions AS A SET A.QuestionID = (SELECT Q.ID FROM
tblQuestions As Q WHERE A.ChecklistID = Q.ChecklistID AND A.Sequence =
Q.Sequence);

Why this message? A.QuestionID is not defined in a relationship.
 
Would the A.CheckListID be the issue because the alias 'A' is not defined
within the Select query?

In other words, this line: WHERE A.ChecklistID
Does it scope to the alias in Update?
 
Why this message? A.QuestionID is not defined in a relationship.
Click to expand...

Try using a Join rather than a subquery:

UPDATE tblActivityQuestions AS A INNER JOIN tblQuestions AS Q
ON A.ChecklistID = Q.ChecklistID
AND A.Sequense = Q.Sequence
SET A.QuestionID = Q.ID;

You will need a unique Index on the combination of ChecklistID and
Sequence.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Must be an updatable query' problem 3
'operation must use updatable query' message 3
What is wrong with this UPDATE SQL ? 1
Why is this query unupdateable?? 5
Must use an Updateable Query - Issue 0
Error: Operation must use an updatable query 2
Operation must use an updatable query 1
Is there something wrong with my SQL? 3

Back
Top