1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| select m.mess_id, m.mess_expid, m.mess_destid,
m.mess_intitule, m.mess_message, m.mess_date, m.mess_lu, m.mess_annonce_dest, m.mess_annonce_exp, u.u_login,
e.ech_marq_nom, e.ech_modele_nom, e.ech_version_nom, e.ech_image1
from messagerie m, utilisateur u, echange e, contre c , contreveh cv " +
"where mess_destid = '" + DestId + "' and u_id = mess_expid
and ech_u_id = mess_expid and e.ech_u_id = u.u_id
and c.con_ech_id = e.ech_id " +
"and cv.cveh_con_id = c.con_id and e.ech_etat='active'
group by m.mess_id, m.mess_expid, m.mess_destid,
m.mess_intitule, m.mess_message, m.mess_date,
m.mess_lu, m.mess_annonce_dest, m.mess_annonce_exp,
u.u_login, e.ech_marq_nom, e.ech_modele_nom,
e.ech_version_nom, e.ech_image1 |
