join and value not found

[sal21]

Code: Select all

UPDATE ANA INNER JOIN PRE20 ON ANA.CAB = PRE20.CAB SET PRE20.SP = ANA.AG
WHERE (((PRE20.SP) Is Null));

Based this join is possible to update the field PRE20.SP with "9999" if the queryu no match?
Tks.

[HansV]

I'm not sure I understand your question, but perhaps

UPDATE PRE20 SET SP = '9999' WHERE SP Is Null AND CAB Not In (SELECT CAB FROM ANA)