UPDATE makes cells NULL

[enginoren]

Hi,

I'm trying to update a coloumn in table A with the corresponding values in table B. It updates the values correctly for the rows that meet the criteria, but changes the values of other rows to NULL.

update ALTMALZEME
set PROJEKODU = (select YENIPROJE from SevkiyatTMP WHERE SevkiyatTMP.MAL ZEMENO = ALTMALZEME.ALTM PKOD)

the Select command works fine and selects the needed rows, but the remaining rows get the value NULL in the coloumn PROJEKODU.

How can i exclude the remaining rows?

Thanks

[enginoren]

update ALTMALZEME
set PROJEKODU = SevkiyatTMP.YEN IPROJE
FROM dbo.ALTMALZEME INNER JOIN dbo.SevkiyatTMP
ON dbo.ALTMALZEME. ALTMPKOD = dbo.SevkiyatTMP .MALZEMENO

This solved my problem :)

[OraMaster]

Hello

Slight modification in your update query

update ALTMALZEME
set PROJEKODU = SevkiyatTMP.YEN IPROJE
FROM dbo.ALTMALZEME INNER JOIN dbo.SevkiyatTMP
ON dbo.ALTMALZEME. ALTMPKOD = dbo.SevkiyatTMP .MALZEMENO
WHERE PROJEKODU <> SevkiyatTMP.YEN IPROJE

Since I think there is no point in updating the column value with same value.

[enginoren]

Thanx for the advice OraMaster, you are right about the point but there will not be such possibility. The new value will always be different. But thanx for reminding, will be handy somewhere else ;)

thanx
Engin