delete from reportlookup where reportlookup.reportnum in (select reportnum from report where runtype in ('ESPREADSHEET', 'QUERY', 'REPORT')) or reportlookup.reportnum is null or reportlookup.reportname is null; delete from reportlabel where reportname like '%.rox' or reportname like '%.dox' or reportname like '%.vts' or reportname like '%.vtf'; delete from report where reportname like '%.rox' or reportname like '%.dox' or reportname like '%.vts' or reportname like '%.vtf';
Labels: report