Hi All,
There is probably an easy answer to this but I haven't found it.
I am comparing two tables. One table is the Production table and the other is the Update table. I have fields that are being compared and if there is a change from what is in the Production (LIVE) table and what is in the Update table then I want to change only the field that changed.
There are about a dozen fields that need to be compared and updated if changed.
I was using UpdateTable.Region <> ProductionTable.Region or UpdateTable.Quantity <> ProductionTable.Quantity, etc but this isn't working.
I can see that there are difference fields but this logic isn't picking it up. My question is why doesn't this work and what kind of query logic do I need to use to be able to filter out the differences?
Thank you,
Sally Vega, MBA
Supply Chain Data Analyst
Super First Class Products
B/E Aerospace, Inc.
1851 S. Pantano Rd.
Tucson, AZ 85710 USA
(520) 239-4812
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar