lundi 23 novembre 2015

SQLite not reading my sql queries

In the sqllite command line I am executing a sql file as:

.read mysquery.sql

I am getting the error

Error: near line 13: near "SELECT": syntax error

The line 13 in my sql file is:

SELECT c.kid as name, l.studentID as no
FROM student c, school l, principal b
WHERE c.cname = b.name

I cannot seem to figure out where the syntax error is occuring. Could someone tell me what I am doing wrong?

Aucun commentaire:

Enregistrer un commentaire