Update Query

[iamtrying]

Hello,

I have two tables employee and cognosEmpData. I need to match the SSN in both tables and update the personelID column in the employee table if there are matching SSNs. For the remaining non matches,I would like to update the complete record record set from cognosEmpData to employee. Here is what I have so far:

update DBO.employee
set DBO.employee.sSN = DBO.cognosEmpData.SSN
from DBO.cognosEmpData
inner join DBO.employee ON DBO.cognosEmpData.SSN = DBO.employee.sSN
where DBO.employee.personnelID = DBO.cognosEmpData.personnelIDwhere DBO.employee.personnelID = DBO.cognosEmpData.personnelID

 

[Turkbear]

Hi,
The Merge method should do what you need:

http://www.oracle-base.com/articles/10g/MergeEnhancements10g.php

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[karluk]

The fact that your table owner is "DBO" strongly suggests that you are using SQL Server for your rdbms, not Oracle. If so, you should repost this question in a SQL Server forum, probably forum183. There are quite a few differences between Oracle and SQL Server, so solutions that will work in Oracle might not work for you.