select filename from zz_tmp_Network_Image_Cleanup with (nolock) where filename = select f.contentid, i.linkid, linkType, ownerid, ownerType, uploaddate, fileSize from tbl_PRD_Images i with (nolock) inner join tbl_FSC_Content f with (nolock) on i.contentid = f.contentid where i.ownerid = and i.ownerType = and f.subFolder = 'PRD' and f.filename = insert into zz_tmp_Network_Image_Cleanup(filename,ownerid,ownerType,contentid,linkid,linkType,uploaddate,filesize,imageFound) values (, , , , , , , , 'Yes' 'No' )

Completed - #dateformat(now(),"mm-dd-yyyy")# - #timeformat(now(),"hh:mm tt")#