Hallo Barracuda, versuch mal folgende Abfrage: SELECT obj_main.isys_obj__id AS 'ID', (CASE obj_main.isys_obj__status WHEN 1 THEN 'LC__CMDB__RECORD_STATUS__BIRTH' WHEN 2 THEN 'LC__CMDB__RECORD_STATUS__NORMAL' WHEN 3 THEN 'LC__CMDB__RECORD_STATUS__ARCHIVED' WHEN 4 THEN 'LC__CMDB__RECORD_STATUS__DELETED' END) AS 'LC__UNIVERSAL__CONDITION' , jn1.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###1', j3.isys_obj__title AS 'LC__CMDB__CATG__LOCATION###26' , loc.isys_catg_location_list__description AS 'Beschreibung' FROM isys_obj AS obj_main LEFT JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id LEFT JOIN isys_obj_type AS jn1 ON jn1.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id LEFT JOIN isys_catg_location_list AS loc  ON loc.isys_catg_location_list__isys_obj__id = obj_main.isys_obj__id LEFT JOIN isys_obj AS j3 ON loc.isys_catg_location_list__parentid = j3.isys_obj__id WHERE TRUE AND obj_main.isys_obj__status = 2; Gruss, jkondek