Zolf
asked on
SQL Query Help
Hello there,
I have this sql query which is working as I expect but it is also get this null values for each product. How can I exclude those null qtyArrived and BatchNo
I have this sql query which is working as I expect but it is also get this null values for each product. How can I exclude those null qtyArrived and BatchNo
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
2-18-2014-1-06-15-PM.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER