Update query-update a field if matching asset #

[Guest]

I have a query that is linking to several tables (fixed asset table,
businessUnit table, oldassetnum table). What is the best way to update a
field with "Old" in the fixed asset query if the asset# in oldasset table =
asset# in the fixed asset query. The fixed asset query has 20028 records
whereas the oldasset table has only 89 records. I will later filter out
those records with "Old" in the disposedasset field.

Thank you!

 

[Saran]

Update Fixed_Asset set A_Field = 'Old' where Asset_Number in (Select
Asset_Number from Old_Asset)

Hope this works for you.

Thanks,
Saran.