Pros (John V?) – query pro! J
I need to get alter a field on a table based on if 2 different fields aren’t on another table.
So, left joined table pn1 won’t have a match on the parts table pn and neither will the left joined table pn2 have a match on the parts table pn.
Here’s the sql to get the dataset that I will do the update on:
SELECT [NogalesCNCBacklog - all].ID
FROM ([NogalesCNCBacklog - all] LEFT JOIN NogalesParts ON [NogalesCNCBacklog - all].Drawing = NogalesParts.PartNum) LEFT JOIN NogalesParts AS NogalesParts_1 ON [NogalesCNCBacklog - all].SolutionItem = NogalesParts_1.PartNum;
Will it work?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
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.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar