What you tried made no sense. You can only use a table name in a statement if it's the "primary" table of the statement (for UPDATE and DELETE) or was explicitly introduced into the statement by FROM clause (for SELECT). You can't just throw in any odd table, because you can't then specify which row or rows of this table you want to use.
I mean't when I tried this... update Parameters set value = (select value from WorkingParameters wp); When you execute this, it works, but it takes the first result row from value and copies it into all the rows of parameters. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
