Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
SELECT supplierOrderDetails.productID as productid, supplierOrder.id as supplierorderid, product.brandname as brandname, product.productcode as code, supplierOrderDetails.orderQty as orderQty, supplierOrderDetails.id as sodID, SUM(supplierOrderReceiveDetail.qtyArrived) as qtyArrived , supplierOrderReceiveDetail.batchNo as BatchNo FROM supplierOrder LEFT OUTER JOIN supplierOrderDetails ON ( supplierOrderDetails.supplierOrderID = supplierOrder.ID ) LEFT OUTER JOIN product ON ( product.id = supplierOrderDetails.productID ) LEFT OUTER JOIN supplierOrderReceive ON ( supplierOrderReceive.supplierOrderID = supplierOrder.ID ) LEFT OUTER JOIN supplierOrderReceiveDetail ON ( supplierOrderReceiveDetail.supplierOrderReceiveID = supplierOrderReceive.ID ) AND ( supplierOrderReceiveDetail.ProductID =supplierOrderDetails.ProductID ) WHERE supplierOrder.ID = 1 and supplierOrderDetails.isComplete = 1 GROUP BY supplierOrderDetails.productID, supplierOrderDetails.orderQty, product.brandname, product.productcode, supplierOrder.id, supplierOrderDetails.id, supplierOrderReceiveDetail.batchNo
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.