Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
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, supplierOrderReceiveDetail.expDate 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 GROUP BY supplierOrderDetails.productID, supplierOrderDetails.orderQty, product.brandname, product.productcode, supplierOrder.id, supplierOrderDetails.id, supplierOrderReceiveDetail.batchNo, supplierOrderReceiveDetail.expDate
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Get Store Procedure Column Name As Row||5||41|
|Need help with convert Informix SQL SELECT statement to Microsoft SQL||1||26|
|SQL- GROUP BY||4||26|
|How to add an Index to a date/time field?||15||15|