SELECT imgid, HighResContentID, lowRes, q2.filename HighRes FROM ztbl_IMG_SimplotExport tmp LEFT OUTER JOIN tbl_FSC_Content fsc2 ON (tmp.HighResContentID = fsc2.ContentID) LEFT OUTER JOIN qryDocFullPathLookup q2 ON (fsc2.ContentID = q2.ContentID) WHERE q2.filename LIKE '%.zip' AND highResFileName_Extracted IS NULL UPDATE ztbl_IMG_SimplotExport SET HighResFileName_Extracted = WHERE imgID =

FINISHED