Search results

I have trouble with this query: UPDATE Table1 IN '' ';Database=C:\data.mdb;PWD=xyz' AS T1 INNER JOIN Table2 ON T1.ID=Table2.ID SET T1.Field1=Table2.Field2 WHERE Table2.Field3='something' I have this error message ,,Syntax error in UPDATE statement,, Thanks for your help.