SQL Errormessage (PROD) :
On itcap.nl.-database at in query :

SELECT DISTINCT e.pers_id FROM employee e, profiles p, persons pe WHERE e.pers_id = p.pers_id AND p.pers_id = pe.pers_id AND p.profiles_status != 'CLOSED' AND e.emp_status != 'CLOSED' ORDER BY pers_lname, pers_mname, pers_fname, pers_init

Error Number : 3065
Module :
Error Message : Expression #1 of ORDER BY clause is not in SELECT list, references column 'itcap.nl.pe.pers_lname' which is not in SELECT list; this is incompatible with DISTINCT

Please, mail this message to your administrator