Hi all, thank you for your help. The problem seems to be SQL studio. DB Browser (SQLite) as well as a VB.net application executes the query fine.

Thank you very much Ken. Works perfectly in SQL, but in Sqlite it complains :

Error while executing SQL query on database 'weegbrugGeskiedenis': near "(": syntax error

The squigly line starts at ...

Thank you anyway Phil.

Hi Phil - thank you.  Can you suggest a forum? I have tried https://sqlite.org/support.html, just cannot figure out how to ask a question.

• This reply was modified 4 years, 11 months ago by  gideon.e.

Thank you Jeff. Yes I am painfully aware that the code is different. It took me a very long time to figure out the SQL query and am really struggling...

Thanx Tom. You are right,but I just cannot figure out how to update an SQlite table without using inner join. I understand SQL, but SQLite has me stumped. I want...

Thank you both Des and John. Both queries works. And I must say both are very impressive. A newbie like me would never have gotten it. Thank you once again.

I am also attaching a script file for both the schema and data.

Hi Saravan. Thank you. Icannot figure out how to do that in Visual Studio Community 2015 with a local .mdf database.