Forget about this one, I can of course just to do:
UPDATE
table1
SET col2 =
(SELECT
t2.col2
FROM
table2 t2
WHERE
table1.ROWID = t2.col1)Must have been looking too much at complex things, so overlooking the simple ones. RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
