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