INSERT INTO not working

Why do I get :- Unexpected token ., requires FROM in statement [INSERT INTO “WordSubject”(“WordsID”,“SubjectID”) (SELECT “WordsTable” .]

Full statement is :- INSERT INTO “WordSubject”(“WordsID”,“SubjectID”) (SELECT “WordsTable” . “ID” AS “WordsID”, “SubjectTable”.“ID” AS “SubjectID” FROM “WordsTable”,“SubjectTable” WHERE “WordsTable”.“Subject” LIKE ‘%country%’ AND “SubjectTable”.“ID” =‘1’)

WordSubject is a 2 field table containing “WordsID”,“SubjectID” that already exists.

The select statement works fine on it’s own.

This is executed in the Tools>SQL dialogue.

I am using Libre Office Version: in Linux Mint 19.1 with HSQLDB.


Brilliant, Thank you. Don’t always see the obvious!

@TrevJ: Please mark the answer as correct. See guidelines for asking.


Not the proper place to respond to my answer. You are actually responding to the posted question. Only saw this because of upvote (Thanks most likely to @jimk ).

Responses should be under the answer you are responding to so a notification is giver to the person responding to. Otherwise that person may never see important information.


You have extra spaces at:

 "WordsTable" . "ID"

Removing the spaces so it is:


worked in my testing.

OK , Noted.