Guest User

Untitled

a guest
Jan 23rd, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. `INSERT INTO producto_detalle
  2. (
  3. id,
  4. producto_id,
  5. precio_compra,
  6. precio_venta,
  7. iva,
  8. ultima_compra,
  9. proveedor_id,
  10. descuento,
  11. stock_ideal,
  12. stock_maximo,
  13. stock_id,
  14. consumo_promedio,
  15. multiplo_compra,
  16. mercaderia,
  17. sucursal_id,
  18. activo,
  19. created_at,
  20. updated_at,
  21. stock
  22. )
  23. SELECT
  24. (
  25. p2.id,
  26. p2.producto_id,
  27. p2.precio_compra,
  28. p2.precio_venta,
  29. p2.iva,
  30. p2.ultima_compra,
  31. p2.proveedor_id,
  32. p2.descuento,
  33. p2.stock_ideal,
  34. p2.stock_maximo,
  35. p2.stock_id,
  36. p2.consumo_promedio,
  37. p2.multiplo_compra,
  38. p2.mercaderia,
  39. p2.sucursal_id,
  40. p2.activo,
  41. p2.created_at,
  42. p2.updated_at,
  43. p2.stock
  44. )
  45. FROM producto_detalle_antiguo p2;`
Add Comment
Please, Sign In to add comment