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
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.