Requette Mysql vers T-SQL

Version imprimable

21/11/2008, 12h42
abdo1966

Requette Mysql vers T-SQL

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.
21/11/2008, 14h57
SQLpro

voila la solution :
http://sqlpro.developpez.com/cours/sqlaz/select/#L7

Commencez par apprendre la langage SQL ! Mon site web comme mes bouquins peuvent vous y aider...

A +

La reuête

Bonsoir,

La voilà ta requête :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
select e.typemvt as _tmvt, e.datemvt as _date, e.numbon as _nbon, e.immvehic as _camion, 
       ( case e.typemvt when '01' then de.quantite else 0 end ) as m_livraison,
       ( case e.typemvt when '02' then de.quantite else 0 end ) as m_retour,
       ( case e.typemvt when '03' then de.quantite else 0 end ) as m_cession,
       c.nom as nom, c.clcleunik as Id_client, 
       de.emcleunik as Id_emb, ct.numcontrat as num,
       eb.codeemb as num_emb
from encaisse e
    inner join decaisse de
       on ( e.encleunik = de.encleunik )
    inner join contrat ct
       on ( e.cocleunik = ct.cocleunik )
    inner join client c
       on ( ct.clcleunik = c.clcleunik )
    inner join emballag eb
       on ( de.emcleunik = eb.emcleunik )
where encaisse.cocleunik = Saisie_Contrat
order by eb.codeemb, e.typemvt, e.datemvt, e.numbon