INSERT INTO not working

[TrevJ]

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: 6.0.7.3 in Linux Mint 19.1 with HSQLDB.

Thanks

[TrevJ]

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

[jimk]

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

[Ratslinger]

@Trevj

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.

[Ratslinger]

Hello,

You have extra spaces at:

 "WordsTable" . "ID"

Removing the spaces so it is:

 "WordsTable"."ID"

worked in my testing.

[TrevJ]

OK , Noted.
Thanks