济南用友软件www.jinanyonyou.com SELECT CurrentStock.cWhCode AS [仓库编码],Warehouse.cWhName AS [仓库名称],Inventory .cInvCCode AS [存货分类编码],InventoryClass .cInvCName AS [存货分类名称],CurrentStock.cInvCode AS [存货编码],  Inventory.cInvStd AS [规格型号],CurrentStock.iQuantity AS [结存数量], Inventory.cComUnitCode AS [主计量单位编码],ComputationUnit.cComUnitName AS [单位], CurrentStock.fOutQuantity AS [待发货数量],  CurrentStock.fInQuantity AS [待入库数量],CurrentStock.fTransInQuantity AS [调拨在途数量],    CurrentStock.fTransOutQuantity AS [调拨待发数量],CurrentStock.fAvaQuantity AS [可用数量]    from CurrentStock  INNER JOIN Warehouse  ON  CurrentStock.cWhCode = Warehouse.cWhCode     LEFT JOIN Inventory   ON  CurrentStock.cInvCode = Inventory .cInvCode   LEFT JOIN InventoryClass   ON  Inventory.cInvCCode = InventoryClass .cInvCCode  INNER JOIN ComputationUnit  ON ComputationUnit.cComUnitCode = Inventory.cComUnitCode