My tests show that no data are returned because the table "ligne" is empty. This table is used in the query to link "validation_parametre" to "groupe_analyse", which is used to get related tables "laboratoire", "type_prelevement", "matrice", "dispositif", "plateforme", "observatoire", "unite" and "methode" , which contains the real data we want to display.
So, is it normal that the "ligne" is empty? If yes, I quickly look about an alternative path to link all those tables, but as there a lot of combinaisons, can you give me a hint about how you want to organize data in this new schema?
My tests show that no data are returned because the table "ligne" is empty. This table is used in the query to link "validation_ parametre" to "groupe_analyse", which is used to get related tables "laboratoire", "type_prelevement", "matrice", "dispositif", "plateforme", "observatoire", "unite" and "methode" , which contains the real data we want to display.
So, is it normal that the "ligne" is empty? If yes, I quickly look about an alternative path to link all those tables, but as there a lot of combinaisons, can you give me a hint about how you want to organize data in this new schema?