this code only update values how do we remake our program (delete valuers from Price.Present that absent in [Goods].Remnant )? (1 Viewer)

[sergey123]

we have price table and goods table in access we need to make query to delete all price values from table price that absent in table goods and leave all prices in table price that exist in table goods.
this code only update values how do we remake our program (delete valuers from Price.Present that absent in [Goods].Remnant )?**
UPDATE Price INNER JOIN Goods ON [Price].Article = [Goods].Article SET Price.Present = [Goods].Remnant;

 

[arnelgp]

backup table Price first!

UPDATE Price SET Price.Present = Null Where Price.Present Not In (SELECT Remnant FROM Goods);