Hi I am a SQLite newbie. Can anyone please tell me why the following query results in the reported error sqlite> UPDATE [activity_overview] INNER JOIN [query_projects] ON [activity_overview].[Project ID] = [query_projects].[Project ID] SET [activity_overview].[C3] = 1 WHERE [query_projects].[Planned Start]) > [activity_overview].[Early Start] ...> ; Error: near "INNER": syntax error sqlite> The same query works on other SQL systems such as MS Access. Thanks in anticipation of your help JZ