Update a Table

[vk4uu4vk]

How can we update TableA based the corresponding value in TableB
ie I have two table OrgMembers and CopyMembers

the query is :
Update OrgMember Set OrgMember.LeftPaid=CopyMember.LeftPaid Where OrgMember.UserID=
CopyMember.userID


I get an error :
The column prefix 'CopyMember' does not match with a table name or alias name used in the query.

Thanks,
VK

[Sivar]

Hi,

Just add From Clause with you statment.

Update OrgMember Set OrgMember.LeftPaid=CopyMember.LeftPaid FROM COPYMEMBER Where OrgMember.UserID=
CopyMember.userID


Regards

Sivar

[davide++]

Hi all,

Try a query like this

Update OrgMember O
Set O.LeftPaid = (SELECT C.LeftPaid
FROM CopyMember C
Where O.UserID = C.userID)
WHERE 0.UserID = (SELECT C.UserID
FROM CopyMember C
Where O.UserID = C.userID)

I haven't tried it, but I think it works correctly.

[vk4uu4vk]

thanks 4 u r replay

[cjard]

why dont you tell us what database technology youre using first?