postgresql7.4 SELECT s.title || ' ' || u.first_names || ' ' || u.last_name AS name, s.position, s.department_id, d.department_name, s.staff_id, u.email, u.url, s.address, s.phone, s.fax, s.homepage_url FROM cc_users u, cc_staff s, cc_department d WHERE s.staff_id = u.user_id AND s.staff_id = :staff_id AND d.department_id = s.department_id ORDER BY department_id, u.last_name ASC