title: How to copy data from 30row to new table with 3 rows
body: <p>I copinig here date from TABLE_PRODUCT  that have info in 30 rows to  TABLE_PRODUCT_CATEGORY_ORDER with  3 rows this script is working i i do this one by one there are any way to make this script shorter?</p>
  
  <pre><code>         INSERT INTO TABLE_PRODUCT_CATEGORY_ORDER (ProductShortID,CategoryID,Priority) SELECT TABLE_PRODUCT.ID,TABLE_PRODUCT.ProductCat ,TABLE_PRODUCT.ProductPriority    FROM TABLE_PRODUCT 
              INSERT INTO TABLE_PRODUCT_CATEGORY_ORDER (ProductShortID,CategoryID,Priority) SELECT TABLE_PRODUCT.ID,TABLE_PRODUCT.ProductSubCat1 ,TABLE_PRODUCT.ProductPriority1    FROM TABLE_PRODUCT 
              INSERT INTO TABLE_PRODUCT_CATEGORY_ORDER (ProductShortID,CategoryID,Priority) SELECT TABLE_PRODUCT.ID,TABLE_PRODUCT.ProductSubCat2 ,TABLE_PRODUCT.ProductPriority2    FROM ............
  ............
  ..........
  
  
              INSERT INTO TABLE_PRODUCT_CATEGORY_ORDER (ProductShortID,CategoryID,Priority) SELECT TABLE_PRODUCT.ID,TABLE_PRODUCT.ProductSubCat9 ,TABLE_PRODUCT.ProductPriority9    FROM TABLE_PRODUCT
  </code></pre>