Know the location of SQL error or missing database (near ".": syntax error) #11185
Unanswered
artgoldberg
asked this question in
Q&A
Replies: 1 comment
-
Found my error. EverSQL SQL Query Syntax Check & Validator is really helpful. Try it. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Receiving this error:
Using the Sample SQLite database. I want to know the location of the error.
The query:
SELECT users.fname, users.lname, users.email, users.username
users.user_id = roles.user_id AND roles.user_role = "CQT",
users.user_id = roles.user_id AND roles.user_role = "MSDW"
FROM users, roles
WHERE users.user_id = roles.user_id AND
(roles.user_role = "CQT" OR roles.user_role = "MSDW") AND
NOT EXISTS (SELECT 1 FROM roles
WHERE users.user_id = roles.user_id AND
roles.user_role = "SC")
GROUP BY users.fname, users.lname, users.email, users.username;
I cannot derive more information from the detailed error (also, cannot copy the detailed error's text). Gotta love screenshots!:
DBeaver 7.3.3.202101161839
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions