Home » RDBMS Server » Server Administration » trying to update a column in table A with a column
trying to update a column in table A with a column [message #371396] Thu, 12 October 2000 13:51
Eric
Messages: 78
Registered: April 1999
Member
I`m trying to update a column in table A with a column
from table B
I've tried this code but it gives me an error....

UPDATE COMPANY
SET COMPANY.MEMBER_GROUP = MEMBERSHIP.MEMBER_GROUP
FROM COMPANY , MEMBERSHIP
WHERE COMPANY.CUSTOMER = MEMBERSHIP.SHIP_CUSTOMER

Report message to a moderator

Previous Topic: Database e-mail
Next Topic: Oracle 8i Installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 16:11:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.