Error Number: 1054

Unknown column 'img' in 'where clause'

SELECT pu_affiliation.college_name, pu_affiliation.college_id FROM pu_affiliation JOIN pu_affcollege_course ON pu_affcollege_course.college_id = pu_affiliation.college_id WHERE pu_affcollege_course.course_id =img and pu_affiliation.status="Active" order by pu_affiliation.college_name asc