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