I want to update joinging with three table

Posted by Nuwan under Sql Server on 1/9/2012 | Points: 10 | Views : 1007 | Status : [Member] | Replies : 5
Dear Friend

I have a three tables(like A,B,C) in this table CNO is a Foreign key in each table, i want to joing in each table then
Update C table one column.

Please help me that matter.

Rathnayake


Responses

Posted by: Blessyjees on: 1/9/2012 [Member] Bronze | Points: 25

Up
0
Down
hi,

Your request is not clear. Do you want to join three tables for updation?

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nuwan on: 1/9/2012 [Member] Starter | Points: 25

Up
0
Down
Yes Blessyjees Please help me.

Rathnayake

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Blessyjees on: 1/9/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi,

Please explain your scenario for joining tables in updation. You can use normal join for this.

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nuwan on: 1/9/2012 [Member] Starter | Points: 25

Up
0
Down
Thanks Friend Finally I do it ....
UPDATE ARR_FULL
SET BANK_UP = 'Z'
FROM ARR_NOV INNER JOIN
ARR_DEC ON ARR_NOV.CNO = ARR_DEC.CNO INNER JOIN
ARR_FULL ON ARR_DEC.CNO = ARR_FULL.CNO
WHERE (ARR_NOV.TOTAGE = '0') AND (ARR_DEC.TOTAGE = '1')

that is my query......

Rathnayake

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nuwan on: 1/9/2012 [Member] Starter | Points: 25

Up
0
Down
Thanks All....

Rathnayake

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response