Hi
I have a requirement like this below.
Table A contains data as below.
id Name Tasks
1
test IA
2 best ABC
3 zest IA
4 east BCD
5 west IA
Now column id is a foreign key referring to column cid in table B
cid Name
1 test
2 zest
3 east
4 west
Now my requirement is to update the table A's "Tasks" column based on the following conditions:
1> when Table A's "id" and Table B's "cid" columns match.
2>only update task column when it contains value as "IA" with ""(blank)
Can any one please help me?