troubleshooting Question

MS Access update a table with condition joining to another table

Avatar of Sam OZ
Sam OZFlag for Australia asked on
DatabasesMicrosoft Access
1 Comment1 Solution85 ViewsLast Modified:
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)

  https://www.experts-exchange.com/questions/29083921/update-Oracle-11g-table-tblA-based-on-a-condiion-on-tblA-and-tbl2.html
ASKER CERTIFIED SOLUTION
ste5an
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros