The table "extended" is not known to the update command. You shoud use a syntax like
this:
UPDATE table1 SET table1.field1 = (select field2 from table2 where
table2.id=table1.id).
- Frank
>I am trying to update a table with data from another table within the same
>database with the following SQL
>
>UPDATE common SET common.[Extended Description] = extended.[Extended
>Description] WHERE common.[id] = extended.[Extended Description]
>
>the id is the primary key. I keep getting the following error.
>
>Server: Msg 107, Level 16, State 3, Line 1
>The column prefix 'extended' does not match with a table name or alias name
>used in the query.
>Server: Msg 107, Level 16, State 1, Line 1
>The column prefix 'extended' does not match with a table name or alias name
>used in the query.
>
>
>Anyone have any ideas.
>
>
>Ryan
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
