A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'educheri_educationheritage.subjects.code' which is not in SELECT list; this is incompatible with DISTINCT

select distinct raw.subject as code, subjects.subject as subject from raw,subjects where raw.subject=subjects.code order by subjects.code asc

Filename: /home3/42/educheri/www/educationheritage/ci/models/bcthm_db.php

Line Number: 266