Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock
- stock_id
- p_id
- stock_qty
- product
- p_id
- p_name
- delivery
- d_id
- d_datetime
- withdrawal
- w_id
- w_datetime
- wd
- p_id
- wd_qty
- dd
- p_id
- dd_qty
- SELECT product.p_id AS 'ID',
- product.p_name AS 'Item Name',
- stock.stock_datetime AS 'Last Stock Update',
- IFNULL(stock.stock_qty,0) AS 'Beginning Count',
- IFNULL(SUM(dd.dd_qty),0) AS 'Total Delivery',
- IFNULL(SUM(wd.wd_qty),0) as 'Total Withdrawals',
- IFNULL(stock.stock_qty+SUM(dd.dd_qty)-SUM(wd.wd_qty),0) AS 'Remaining'
- FROM product
- LEFT JOIN stock ON
- stock.p_id=product.p_id
- LEFT JOIN wd ON
- product.p_id =wd.p_id
- LEFT JOIN dd ON
- product.p_id =dd.p_id
- INNER JOIN
- delivery d ON d.d_id =dd.d_id
- INNER JOIN
- withdrawal w ON w.w_id=wd.w_id
- WHERE w.w_datetime AND d.d_datetime BETWEEN '2016-01-01 00:00:00' AND Now()
- GROUP BY product.p_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement