Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- copy branch supplier products from preston to gateshead (create these branch_supplier_products records) >>>
- select '{next_id}' AS id, '{created_by_other_query}' AS branch_supplier_id, product_id, 0 AS stock_level, cost, sell_type, sell_value, product_code, now() AS created_at, now() as updated_at, NULL as deleted_at from branch_supplier_products where branch_supplier_id in (select id from branch_suppliers where branch_id = 33 and deleted_at is null) and deleted_at is null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement