1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| SELECT art.arti_code "Art"
, art.arti_designation "désign"
, art.arti_qte_stock_ue "En stock"
, art.arti_stock_minimum "seuil"
, cla.clar_clnt_code "Client"
, stm.stmv_dt_mvt "Dt mvt"
, stm.stmv_qte_ue "Qté"
, stm.stmv_numero "N°"
FROM article art
INNER JOIN
client_article cla
ON cla.clar_arti_code = art.arti_code
INNER JOIN
stock_mouvement stm
ON art.arti_code = stm.stmv_arti_code
WHERE art.arti_gestion_source = 'F'
AND art.arti_code IN ('903548', '903547')
AND EXISTS
( SELECT NULL
FROM stock_mouvement sel
WHERE stm.stmv_arti_code = sel.stmv_arti_code
HAVING stm.stmv_dt_mvt = MAX(sel.stmv_dt_mvt)
)
ORDER BY art.arti_code
, stm.stmv_numero DESC
; |
Partager