SELECT ID_KBS, tblFFHKBS.ID_Art, Art_Deutsch, Art_wissenschaftlich, BfN_Code, ID_KBSGruppe,
Kriterium, Kriterium_Info, Einheit, A, B, C, ID_Mapping, JahrVon, JahrBis, ID_DataType,
Grenze_A, Grenze_C, IDs_Required, ID_Sort, tblFFHKBS.Flag_Visible, Flag_Begruendung
FROM tblFFHKBS
INNER JOIN tblArten ON tblFFHKBS.ID_Art = tblArten.ID_Art
WHERE ID_Projekt = 1 AND ISNULL(tblFFHKBS.Flag_Deleted, 0) = 0
AND JahrBis IS NULL AND ISNULL(tblFFHKBS.Flag_20016, 0) = 1
ORDER BY BfN_Code, ID_KBSGruppe, ID_Sort

SELECT ID_KBSLRT, tblFFHKBSLRT.ID_LRT, Bezeichnung, CodeFFH, ID_KBSLRTGruppe,

Kriterium, Kriterium_Info, Einheit, A, B, C, ID_Mapping, JahrVon, JahrBis,

ID_DataType, Grenze_A, Grenze_C, IDs_Required, ID_Sort, tblFFHKBSLRT.Flag_Visible, Flag_Begruendung
FROM tblFFHKBSLRT
INNER JOIN tblFFHLRT ON tblFFHKBSLRT.ID_LRT = tblFFHLRT.ID_LRT
WHERE ISNULL(tblFFHKBSLRT.Flag_Deleted, 0) = 0
AND JahrBis IS NULL AND ISNULL(tblFFHKBSLRT.Flag_20016, 0) = 1
ORDER BY CodeFFH, ID_KBSLRTGruppe, ID_Sort