Hi Everybody,

I have a new SQL riddle to solve.

Given is a cursor

CREATE CURSOR curTable (cTableNumber, iChair)
INSERT INTO curTable VALUES ('1',4)
INSERT INTO curTable VALUES ('2',3)
INSERT INTO curTable VALUES ('3',2)
INSERT INTO curTable VALUES ('4',6)

Now I need to number the Chairs like 1.1,1.2,1.3,1.4 and a recors for each chair

Result

CREATE CURSOR curChair (cTableNumber, cChairNumber)
INSERT INTO curTable VALUES ('1',"1.1")
INSERT INTO curTable VALUES ('1',"1.2")
INSERT INTO curTable VALUES ('1',"1.3")
INSERT INTO curTable VALUES ('1',"1.4")
INSERT INTO curTable VALUES ('2',"2.1")
INSERT INTO curTable VALUES ('2',"2.2")
INSERT INTO curTable VALUES ('2',"2.3")
INSERT INTO curTable VALUES ('3',"3.1")
INSERT INTO curTable VALUES ('3',"3.2")
INSERT INTO curTable VALUES ('4',"4.1")
INSERT INTO curTable VALUES ('4',"4.2")
INSERT INTO curTable VALUES ('4',"4.3")
INSERT INTO curTable VALUES ('4',"4.4")
INSERT INTO curTable VALUES ('4',"4.5")
INSERT INTO curTable VALUES ('4',"4.6")

So how can I use SELECT SQL to achive this? I know I can SCAN and INSERT (etc.), but this is not my problem.

Agnes