turnstyles1
asked on
Updating SQL table with data from another table based on specific values
Hello,
I have the following 2 tables:
TBL1
COL1 COL2
100 A
200 B
300 C
TBL2
COL1 COL2
W 300
X 200
Y 100
Z 300
What I would like to be able to do is update TBL2.COL2 with TBL1.COL1's data based on specific values in TBL1.COL2.
If TBL1.COL2 = C then update TBL2.COL2 with TBL1.COL1's data where TBL1.COL2 = A
So TBL2 will end up looking like this:
TBL2
COL1 COL2
W 100
X 200
Y 100
Z 100
I have the following 2 tables:
TBL1
COL1 COL2
100 A
200 B
300 C
TBL2
COL1 COL2
W 300
X 200
Y 100
Z 300
What I would like to be able to do is update TBL2.COL2 with TBL1.COL1's data based on specific values in TBL1.COL2.
If TBL1.COL2 = C then update TBL2.COL2 with TBL1.COL1's data where TBL1.COL2 = A
So TBL2 will end up looking like this:
TBL2
COL1 COL2
W 100
X 200
Y 100
Z 100
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> If TBL1.COL2 = C then update TBL2.COL2 with TBL1.COL1's data where TBL1.COL2 = A
Didn't understand your statement clearly.