KPI-Object-Equipment relations
SQL
SELECT
fc_kpi_def_equipment.id_kpi_definition AS "ID KPI Definition",
kpi.title AS "KPI Title",
fc_kpi_def_equipment.id_equipment AS "ID Equipment",
eq.description AS "Equipment description",
fc_kpi_def_equipment.id_fc_object AS "ID Object",
ob.title AS "Object title"
FROM fc_kpi_def_equipment
LEFT JOIN fc_kpi_definition kpi ON kpi.id = fc_kpi_def_equipment.id_kpi_definition
LEFT JOIN fc_object ob ON ob.id = fc_kpi_def_equipment.id_fc_object
LEFT JOIN equipment eq ON eq.id = fc_kpi_def_equipment.id_equipment