mardi 12 juillet 2016

Insert to multiple column from single column of another table

I have already table 1 with 3 columns like this:

-------------------
|  A  |  B  |  C  |
-------------------

and table 2:

---------
|  col  |
---------
|   1   |
|   2   |
|   3   |
|   4   |
|   5   |
|   6   |
|   7   |
|   8   |
|   9   |
---------

I want to insert to table 1 from data of table 2 and get the result like this:

-------------------
|  A  |  B  |  C  |
-------------------
|  1  |  4  |  7  |
|  2  |  5  |  8  |
|  3  |  6  |  9  |
-------------------

Any suggestions? Thanks a lot.

Aucun commentaire:

Enregistrer un commentaire