SQL Query in Access missing operator syntax error -

SQL Query in Access missing operator syntax error -

hi created database in microsoft access , have been trying find specific stuff through query's when seek test query maintain getting syntax error saying miss operator query:

select student.name establishment inner bring together major on major.institutionid = institution.institutionid inner bring together class on class.majorid = major.majorid inner bring together pupil on student.classid = class.classid institution.institutionname == cmi && student.gender == boy;

try changing where clause this:

where institution.institutionname = "cmi" , student.gender = "boy";

in ms access, & string concatenation. assume error because string expected between 2 &s.

sql ms-access