SQL Query in Access missing operator syntax error

Question

Hi i created a database in Microsoft Access and i have been trying to find specific stuff through query's but when i try to test my query i keep getting a syntax error saying i miss an operator this is my query:

SELECT student.name
FROM institution 
    INNER JOIN major on major.institutionID = institution.institutionID
    INNER JOIN class on class.majorID = major.majorID
    INNER JOIN student on student.classID = class.classID 
WHERE institution.institutionName == CMI && student.gender == boy;

change the && to AND, && is not sql syntax, you almost might have to wrap CMI in 'CMI' and boy in 'boy' — Kevin Cook
– Kevin Cook, Commented Jun 24, 2014 at 17:33
The == is also not a valid operator. Valid operators are documented here: http://office.microsoft.com/en-us/access-help/table-of-operators-HA010235862.aspx — spencer7593
– spencer7593, Commented Jun 24, 2014 at 17:53

Gordon Linoff · Accepted Answer · 2014-06-24 17:32:59Z

3

Try changing the where clause to this:

WHERE institution.institutionName = "CMI" AND student.gender = "boy";

In MS Access, & is for string concatenation. I assume the error is because a string is expected between the two &s.

answered Jun 24, 2014 at 17:32

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Eccountable · Accepted Answer · 2014-06-24 17:36:30Z

0

use the word AND instead of && in your where clause

answered Jun 24, 2014 at 17:36

Eccountable

6423 silver badges14 bronze badges

1 Comment

spencer7593 Over a year ago

Also, string literals should be enclosed in quotes, and the == is not a valid operator.

Collectives™ on Stack Overflow

SQL Query in Access missing operator syntax error

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related