10 August 2009

Informix: update from another table

update tabA
set tabA.col1 = (select tabB.col1
from tabB
where tabA.key1 = tabB.key1
and tabA.key2 = tabB.key2
and tabB.col2 = '2009-06-01')

No comments:

Post a Comment