|
Could someone give me an example of the correct
syntax for updating the values in one table with values from another
table.
They synxtax I use in several other databases, that
I thought was standard to all databases is:
Update table1 set table1.colA = table2.colB from
table2 where (table1.ID = table2.ID)
I get an error that the from was not expected. I
have tried ever other possible combination I can think of to make this work with
no luck.
Any help would be greatly appreciated.
Shawn Gorman
Also, on a similar note. I sometimes get an illegal
mixture of string/numeric but both sides of the = are
integers.
| 
