Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. -- copy branch supplier products from preston to gateshead (create these branch_supplier_products records) >>>
  2. 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