SQL Server CE Update Query Causing Errors

Hello all,





Thought I would post here in case anybody can give some information.





Here is the background information:





I have 2 tables (stores and sales) from the Pubs database in Sql Server 2000 copied down to a SQL Server CE database. There is no foreign key/primary key relationship between the 2 tables in the CE database.





Here are the update queries that cause the error:





UPDATE st


SET st.zip = 66668


FROM stores st


INNER JOIN sales sa ON st.stor_id = sa.stor_id


AND st.stor_id = 6380





Update stores SET stores.zip = 55555


FROM sales, stores


WHERE stores.stor_id = 6380


AND stores.stor_id = sales.stor_id





Here is the error message that is generated when I run the query (Param 0 and Param 1 change according to what column and line the FROM clause is in):





Error: 0x80040e14 DB_E_ERRORSINCOMMAND


Native Error: (25501)


Description: There was an error parsing the query. [Token line number,Token line offset,,Token in error,,]


Interface defining error: IID_ICommand


Param. 0: 2


Param. 1: 1


Param. 2: 0


Param. 3: FROM


Param. 4:


Param. 5:





I ran the 2 queries in SQL Query Analyzer in SQL Server 2000 and they worked just fine. I also created 2 new tables (stores1 and sales1) in SQL Server 2000 using the Select Into clause. The new tables were created from the sales table and stores table in the Pubs database. The new tables had no foreign key/primary key relationship.





I ran the queries again in Query Analyzer against the new tables and the queries produced no errors.





Any suggestions?





Thank you,


Aaron B