Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Update Query (3 criteria)

Steel Contributor

Hello Experts,

 

I need to update a field tbl1.WDDate to the value showing in tbl2.WDDate but only where the [InvNo] and [InvAmt] and [InvDate] are equal between the files.  

 

How could I do this?   thank you. 

1 Reply

@Tony2021 

 

Your question has languished unanswered for a while. That might be because it's not entirely clear what needs to happen.

 

First, on the surface it looks like you want to duplicate data in two different tables; that's generally an undesirable thing to do in a relational database application, so that might be putting some folks off on trying to answer. 

 

More to the point, we have only tbl1 and tbl2 to work with, and that kind of ambiguity makes us uneasy as well. What are those tables, really? Aliasing object names actually tends to make it harder to figure out how to address problems.

 

The actual query that would do this might be quite straightforward, but given the ambiguity, perhaps we should figure out more clearly what needs to happen, and why.