I have this problem, which for now is NOT something I have
created, yet. However the problem remains.
We have to UPDATE TABLE A -
TABLE A Columns xCode, yCode, EndValue
TABLE B Columns yCode, EndValue
TABLE C Columns yCode, EndValue
Condtions for UPDATE
IF TABLE A.xCode starts with a 1
then UPDATE TABLE A.EndValue = TABLE C.EndValue
WHERE TABLE A.yCode = TABLE C.yCode
Otherwise UPDATE TABLE A.EndValue = TABLE B.EndValue
WHERE TABLE A.yCode = TABLE B.yCode
So my question is how would I perform this type of update ?
PLEASE NOTE ( before someone says - "Put ...