complex inserting a number of rows based in the value of one field on other table

• luisalfonso70

  SSC-Addicted

  Points: 410

  More actions

  May 19, 2009 at 2:47 am

  #134427

  Hi, any ideas for the next :

  I have the next table orders_resume

  id orders

  1 45

  2 60

  3 5

  4 1

  and now I want to populate an other table called orders inserting rows depending of the number of the orders_resume.orders, so for the orders_resume.id=3 the inserted rows will be 5, for the id=1 45 rows, etc....:

  id order

  3 1

  3 2

  3 4

  3 5

  thanks for the tipssss!!!

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  May 19, 2009 at 3:55 am

  #996809

  Don't cross post, continue discussions here

  --Ramesh
  

  ---