Sql Query for Single & parent item Quantity

Hi All
I would like to know if there Sql Query to convert the quantities of Parent item to be Single item , i would explain it with an example
single item Itemlookupcode is 123456 and Qty 1
Parent item (outer pack of single item) like 6 cans of cola drink forms a pack which can be sold as single as well as pack item Itemlookupcode 123456-06 Qty 2
I need an sql query to produce result like 123456 QTY = 13 and 123456-06 Qty =0.
Formula = Qty of Single item + Number of pieces in a single pack * Qty of parent item
it would be great help that if it would be possible in sql
Reply to

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.