Quelque chose

SELECT s.id_aclsbj,        s.id_aclvalgrp,        s.label_key,        r.value as right_value,        r.id_aclres,        rv.label_key label_value,        rv.value valueFROM jacl_right_values rvLEFT JOIN jacl_subject s     ON rv.id_aclvalgrp = s.id_aclvalgrpLEFT JOIN jacl_rights r    ON (s.id_aclsbj = r.id_aclsbj AND r.id_aclgrp =1 AND rv.value=r.value)