I am running SQl_server 6.5 through ODBC from a C++ application.
I tryed to execute the following SQl statement :
UPDATE tableA, tableB
SET tableA.UserName = tableB.NewName
WHERE tableA.Name = tableB.OldName;
but it doesn't work with SQL_Server. It works fine with MS-Access.
I know that It is not a stadard SQL statement but I cannot figure out how to
convert it into standard SQL without using cursors.
So I was wondering if someone can help me out with the followings:
1. how can I convert the aforementiond statement into standard SQL
2. How can I use cursors with ODBC
Thanks a lot.