insert into softwaremeterdetail (siteid,systemid) select DISTINCT smsr.siteid,smsr.systemid from softwaremeterstatusrecord smsr left join softwaremeterdetail smd on smd.siteid=smsr.siteid and smd.systemid=smsr.systemid where smsr.siteid=1 and smd.systemid is null; |
11
|
19,239
|
432
|
|
0.00
|