1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT Piece.Code,
Piece.Nom,
Piece.PxVenteHT,
(Piece.PxVenteHT*(1+IIF(Tva.Taux = Null,0,Tva.Taux)/100)) AS PrixTTC,
Piece.StockPhysique,
Piece.EmplV,
[Famille Piece].Nom,
Marque.Nom,
min(ArticlesRemplacement.CodePieceRemplacante)
FROM ((Piece
LEFT OUTER JOIN ArticlesRemplacement
ON (ArticlesRemplacement.CodePieceRemplacee = Piece.Code))
LEFT JOIN Tva
ON Piece.CodeTva = Val(Tva.Code))
group by Piece.Code,
Piece.Nom,
Piece.PxVenteHT,
Tva.Taux,
Piece.StockPhysique,
Piece.EmplV,
[Famille Piece].Nom,
Marque.Nom
ORDER BY Piece.Code |
Partager