Open jimk-bdrc opened 5 years ago
select d.osn, v.label, w.WorkName, substring(v.label,1,locate('-',v.label)-1) as vWork from DRS d join Volumes v using(volumeId) join Works w using(workId) where substring(v.label,1,locate('-',v.label)-1) <> WorkName; select database();
select d.osn, v.label, w.WorkName, substring(v.label,1,locate('-',v.label)-1) as vWork from DRS d join Volumes v using(volumeId) join Works w using(workId) where substring(v.label,1,locate('-',v.label)-1) <> WorkName; select database();