June 19, 2013 at 7:03 am
I want to update the PO table with the BuyerName if there is a Buyer record exist.
In below example , it should update Buyer field in PO Table with Roger James as there is a record exist for code RAJ.
It should not update PO Table for james Kidlo as there is no Buyer code exist.
PO Table
PO# Buyer
----- ------------
PO001 RAJ
PO002 James Kidlo
Buyer Table
Buyer Name
------ --------------
RAJ Roger James
PRK Paul Kisslebeck
June 19, 2013 at 7:43 am
You're going to have a problem as it looks like you want to update a join key on the PO Table
Why do you want to update the PO Table? Which column do you want to update?
June 19, 2013 at 7:59 am
Consider normalizing these tables in future.
For now, Check if this works:
Update POTable
set Buyer = PO.Name
FROM POTable PO inner join BuyerTable BT
ON PO.Buyer = BT.Buyer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy