Voila ma requette :


"SELECT encaisse.typemvt as _tmvt, encaisse.datemvt as _date, encaisse.numbon as _nbon, encaisse.immvehic as _camion, if(encaisse.typemvt = '01',decaisse.quantite, 0 ) as m_livraison, "+...
"if(encaisse.typemvt = '02',decaisse.quantite, 0 ) as m_retour, "+...
"if(encaisse.typemvt = '03',decaisse.quantite, 0 ) as m_cession, "+...
"client.nom as nom, client.clcleunik as Id_client, "+...
"decaisse.emcleunik as Id_emb, contrat.numcontrat as num, "+...
"emballag.codeemb as num_emb "+...
"FROM encaisse, decaisse, contrat, client, emballag where encaisse.encleunik = decaisse.encleunik and encaisse.cocleunik = contrat.cocleunik "+...
"and decaisse.emcleunik = emballag.emcleunik "+...
"and contrat.clcleunik = client.clcleunik and encaisse.cocleunik = '"+Saisie_Contrat+"' ORDER BY num_emb ASC, _tmvt ASC, _date ASC, _nbon ASC"


Merci d'avance.