/* Selects scan table entries that have the hit flag set but no corresponding entry in the hit table */
USE setine5_seti
SELECT scans.Scan_ID, scans.Target_ID,scans.Hits FROM scans,hits WHERE NOT EXISTS
  (SELECT scans.Scan_ID FROM scans WHERE scans.Scan_ID = hits.Scan_ID) AND scans.Hits  != 0