test.insert-bulk-and-itemcost

gistfile1.txt

INSERT INTO edisonlamps.bulk_units (item_id, name, qty,uom_id, active, type, created_by, unit_code)
SELECT id, "roll", 5, 2, "Active", "base", 1, "roll"
FROM   edisonlamps.items
WHERE  inventory_types_id = 2 and uom_id = 4





INSERT INTO edisonlamps.itemcosts (item_id, itemcost, effective_date)
SELECT id, item_cost, NOW()
FROM   edisonlamps.items