Gfreeman http://www.FGFasp.com | Code :
- str_sql = _
- "SELECT " & _
- "Sous_rubriques.srub_identifiant," & _
- "(" & _
- "SELECT Grp_1.grp_lecture & ',' & Grp_1.grp_ecriture & ',' & Grp_1.grp_modifier " & _
- "FROM Groupes Grp_1 " & _
- "WHERE Grp_1.grp_identifiant IN " & _
- "(" & _
- "SELECT TOP 1 Grp_2.grp_identifiant " & _
- "FROM Groupes Grp_2 " & _
- "WHERE Grp_2.grp_identifiant IN " & _
- "(" & _
- "SELECT Grp_3.grp_identifiant " & _
- "FROM Groupes Grp_3 " & _
- "WHERE Grp_3.grp_visiteur = 1 " & _
- "AND NOT EXISTS " & _
- "(" & _
- "SELECT Guti_4.guti_grp_identifiant " & _
- "FROM Groupes_utilisateurs Guti_4 " & _
- "WHERE Guti_4.guti_grp_identifiant = Grp_3.grp_identifiant" & _
- " ) " & _
- "AND NOT EXISTS " & _
- "(" & _
- "SELECT Gsrub_4.gsrub_grp_identifiant " & _
- "FROM Groupes_sous_rubriques Gsrub_4 " & _
- "WHERE Gsrub_4.gsrub_grp_identifiant = Grp_3.grp_identifiant" & _
- " ) " & _
- "ORDER BY Grp_3.grp_lecture ASC" & _
- " )" & _
- " )" & _
- " )," & _
- "(" & _
- "SELECT Grp_1.grp_lecture & ',' & Grp_1.grp_ecriture & ',' & Grp_1.grp_modifier " & _
- "FROM Groupes Grp_1 " & _
- "WHERE Grp_1.grp_identifiant IN " & _
- "(" & _
- "SELECT TOP 1 Grp_2.grp_identifiant " & _
- "FROM Groupes Grp_2 " & _
- "WHERE Grp_2.grp_identifiant IN " & _
- "(" & _
- "SELECT Grp_3.grp_identifiant " & _
- "FROM Groupes Grp_3, Groupes_sous_rubriques Gsrub_3 " & _
- "WHERE Grp_3.grp_identifiant = Gsrub_3.gsrub_grp_identifiant " & _
- "AND Gsrub_3.gsrub_identifiant = Sous_rubriques.srub_identifiant " & _
- "AND Grp_3.grp_visiteur = 1 " & _
- "AND NOT EXISTS " & _
- "(" & _
- "SELECT Guti_4.guti_grp_identifiant " & _
- "FROM Groupes_utilisateurs Guti_4 " & _
- "WHERE Guti_4.guti_grp_identifiant = Grp_3.grp_identifiant" & _
- " ) " & _
- "ORDER BY Grp_3.grp_lecture ASC" & _
- " )" & _
- " )" & _
- " )," & _
- "(" & _
- "SELECT Grp_1.grp_lecture & ',' & Grp_1.grp_ecriture & ',' & Grp_1.grp_modifier " & _
- "FROM Groupes Grp_1 " & _
- "WHERE Grp_1.grp_identifiant IN " & _
- "(" & _
- "SELECT TOP 1 Grp_2.grp_identifiant " & _
- "FROM Groupes Grp_2 " & _
- "WHERE Grp_2.grp_identifiant IN " & _
- "(" & _
- "SELECT Grp_3.grp_identifiant " & _
- "FROM Groupes Grp_3, Groupes_utilisateurs Guti_3 " & _
- "WHERE Grp_3.grp_identifiant = Guti_3.guti_grp_identifiant " & _
- "AND Grp_3.grp_visiteur = 1 " & _
- "AND NOT EXISTS " & _
- "(" & _
- "SELECT Gsrub_4.gsrub_grp_identifiant " & _
- "FROM Groupes_sous_rubriques Gsrub_4 " & _
- "WHERE Gsrub_4.gsrub_grp_identifiant = Grp_3.grp_identifiant" & _
- " ) " & _
- "ORDER BY Grp_3.grp_lecture ASC" & _
- " )" & _
- " )" & _
- " )," & _
- "(" & _
- "SELECT Grp_1.grp_lecture & ',' & Grp_1.grp_ecriture & ',' & Grp_1.grp_modifier " & _
- "FROM Groupes Grp_1 " & _
- "WHERE Grp_1.grp_identifiant IN " & _
- "(" & _
- "SELECT TOP 1 Grp_2.grp_identifiant " & _
- "FROM Groupes Grp_2 " & _
- "WHERE Grp_2.grp_identifiant IN " & _
- "(" & _
- "SELECT Grp_3.grp_identifiant " & _
- "FROM Groupes Grp_3, Groupes_Sous_rubriques Gsrub_3, Groupes_utilisateurs Guti_3 " & _
- "WHERE Grp_3.grp_identifiant = Gsrub_3.gsrub_grp_identifiant " & _
- "AND Grp_3.grp_identifiant = Guti_3.guti_grp_identifiant " & _
- "AND Gsrub_3.gsrub_identifiant = Sous_rubriques.srub_identifiant " & _
- "AND Grp_3.grp_visiteur = 1 " & _
- "ORDER BY Grp_3.grp_lecture ASC" & _
- " )" & _
- " )" & _
- " ) " & _
- "FROM Sous_rubriques " & _
- "ORDER BY Sous_rubriques.srub_nom ASC"
|
et ça, ça ira )) |