Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
That is my challenge.. I need to:
match the ID from the table to the file names,
where 'no matching ID' action delete file
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
I can't seem to find it ... but with the "old" and "new" data in separate tables, a simple OUTER JOIN will identify the properties that no longer exist in the "new" feed ie The ones you want to delete
SELECT old.PropertyID
FROM OldDataTable old LEFT JOIN NewDataTable nw
ON nw.PropertyID = old.PropertyID
WHERE nw.PropertyID IS NULL
I'm making some assumptions about your app. Like I mentioned earlier, the specifics and exact will really depend on how your current process works. ie How is your new data is imported, how many images, how they're stored etc....