题目
有如下2张表G1024A
G1024B
希望把表G1024A的Charg随机分配到表G1024B里面,但是数量得对上,比如表G1024A的N1对应的QTY是3,则表G1024B只随机分配3个serial_number过去。两个表的关联关系为HU字段,表G1024A的QTY合计一定是表G1024B的条数,预计其中一种结果如下:
测试语句
create table G1024A (HU varchar(20), QTY int, Charg varchar(20));
insert into G1024A values('X', 3, 'N1');
insert into G1024A values('X', 2, 'N2');
create table G1024B (HU varchar(20), serial_number varchar(20));
insert into G1024B values ('X', 'A1');
insert into G1024B values('X', 'A8');
insert into G1024B values('X', 'A3');
insert into G1024B values('X', 'A5');
insert into G1024B values('X', 'A0');