SQL="Select IDmission,Societe.IDsociete,raisonsociale,titremission,statutM,contactM,dateDM,dateFM,"
SQL=SQL & " u1.idutilisateur as id1,u1.nomUser as n1,u1.prenomUser as p1,u2.idutilisateur as id2, u2.nomUser as n2,u2.prenomUser as p2,prenomC,nomC,typeM, "
SQL=SQL & " commentaire,sommeil,codemission from typeMission,Mission,Societe,Utilisateur as u1,Utilisateur as u2,Contact where "
SQL=SQL & " Mission.IDsociete=Societe.IDsociete and u1.IDutilisateur=*mission.IDcM and u2.IDutilisateur=*mission.IDCR"
SQL=SQL & " and Contact.IDcontact=*Mission.contactM and Mission.IDtypeM*=typeMission.IDtypeM"
Partager