CODEWITHSUNDEEP
sqldatabasesqlitems-access
IAteAllThePi
IAteAllThePi

Reputation: 13

SQLite equivalent of SELECT ... INTO in Access SQL

I have a Microsoft Access query which takes some data from 2 separate tables (within the same database) and merges it into a newly created table, the SQL is as follows:

SELECT Student_Answers.Student_Login, Student_Answers.Question_ID, Student_Answers.Status, Student_Answers.TimeStamp, Student_Answers.Student_Answer, Questions.Question_type, Questions.Question_ID INTO [tempAnswered&Unasweredwith_UI]

FROM (Questions LEFT JOIN Student_Answers ON Questions.Question_ID = Student_Answers.Question_ID)

WHERE (((Student_Answers.Student_Login)<>'10l.delbasso' Or (Student_Answers.Student_Login) Is Null));"

When running the same Query in SQLite it tells me that the "INTO" command is not supported. I have tried finding solutions online (for example translators between Access and SQLite) but i cannot find a solution as my problem seems to be quite specific. If anyone could help me to get the SQLite query working i would appreciate it.

Thanks :)

Upvotes: 1

Views: 1164

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123654

As mentioned in this answer to a similar question, SQLite supports

CREATE TABLE table2 AS SELECT * FROM table1

which you can use in place of the SELECT ... INTO table2 FROM table1 form that Access SQL uses.

Upvotes: 1

Related Questions