I need to create 3 columns with 10 lines each, and number them, for example:
1 | 11 | 21
2 | 12 | 22
3 | 13 | 23
4 | 14 | 24
5 | 15 | 25
6 | 16 | 26
7 | 17 | 27
8 | 18 | 28
9 | 19 | 29
10 | 20 | 30
I have a table in SQL which contains items of products. How do I fill in the name of the product next to the item number? For example: If I have 3 products in the table:
1 Product A | 11 | 21
2 Product B | 12 | 22
3 Product C | 13 | 23
4 | 14 | 24
5 | 15 | 25
6 | 16 | 26
7 | 17 | 27
8 | 18 | 28
9 | 19 | 29
10 | 20 | 30
Thanks!
Edited by frias - 24 Feb 2010 at 9:43am