Avatar of Sam OZ
Sam OZ
Flag for Australia

asked on 

MS Access update a table with condition joining to another table

I need to update an MS Access 2003 database  table based on a condition
I tried I tried
update tblA    set Fld1 = B.Fld1   from tblA A inner   join tblB B     on A.Fld2 = B.Fld2    where B.Fld3 not in ( '000' , '001')

Also I tried options from following (It works for oracle. But not for Access)

DatabasesMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon