1 2 3 4 5 6 7 8 9 10
| Select lb_last_name,lb_given_name,dt_compte_rendu,lb_activite ,lb_ss_activite,lb_projet,lb_application
From tr_activite B, tr_sous_activite C , vw_employe D,
tf_compte_rendu a left outer join tr_projet F on a.cd_projet = f.cd_projet,
tf_compte_rendu a left outer join tr_application G on a.cd_application = g.cd_application
WHERE a.cd_activite= b.cd_activite
AND a.cd_ss_activite= c.cd_ss_activite
AND a.cd_login= d.cd_login
AND a.dt_compte_rendu < sysdate
AND cd_compte_rendu in (SELECT Max(cd_compte_rendu) from tf_compte_rendu WHERE cd_login = 'login')
GROUP by lb_last_name,lb_given_name,dt_compte_rendu,lb_activite,lb_ss_activite,lb_projet,lb_application |
Partager