1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
select client.nom as rs,civil.lib|| ' '|| client.contact_prenom || ' '|| client.contact_nom as client_patro ,
cmdcli.cf,article.codeb,article.codeh,article.ref,items.op,items.wkliv,
civil.lib|| ' '|| fournisseur.contact_prenom || ' '|| fournisseur.contact_nom as four_patro,
fournisseur.nom,cmdfou.ac,cmdfou.datecmd,cmdfou.qtecmd,cmdfou.dateliv_th,cmdfou.dateliv_conf,
cmdfou.daterel1,cmdfou.daterel2,cmdfou.rel1,cmdfou.rel2 from cmdfou
join fournisseur on fournisseur.four_id=cmdfou.four_id
join civil on civil.civ_id=fournisseur.civil_id
join items on items.items_id=cmdfou.items_id
join cmdcli on cmdcli.cmdcli_id=items.cmdcli_id
join client on client.cli_id=cmdcli.cli_id
join civil on civil.civ_id=client.civil_id
join article on article.arti_id=items.arti_id
order by items.wkliv |
Partager