1、/*希望把表T0810A的charg随机分配到T0810B里面,但是数得对上,比如表T0810A的N1对应的QTY是3 ,则表T0810B只随机分配3个serial_number过去。
两个表的关联条件为HU字段,表T0810A的QTY合计一定是表T0810B的条数,预计其中一种结果如下*/
HU SERIAL_NUMBER CHARG
X A5 N1
X A3 N1
X A1 N1
X A0 N2
X A8 N2
建表语句:
CREATE TABLE T0810A( HU VARCHAR(20), QTY INT, CHARG VARCHAR(20));
INSERT INTO T0810A VALUES('X',3,'N1');
INSERT INTO T0810A VALUES('X',2,'N2');
CREATE TABLE T0810B(HU VARCHAR(20), SERIAL_NUMBER VARCHAR(20));
INSERT INTO T0810B VALUES('X','A1');
INSERT INTO T0810B VALUES('X','A8');
INSERT INTO T0810B VALUES('X','A3');
INSERT INTO T0810B VALUES('X','A5');
INSERT INTO T0810B VALUES('X','A0');
--解答1
S