3 Replies Latest reply on Sep 7, 2012 12:40 PM by Stephen Huston

    Orphans image Records - delete options / solutions

    ajayz

      Hi guys..

       

      I have a database of billboards and the raw informaiton is provided to me by two files

       

      file 1 - all the billboard data, ie Panel ID, details, address etc

       

      file 2 - all billboard images (4,000) - the file name is Panel ID - 6 digit number

       

      Due to the amount of billboard images it easlier to read the complete FOLDER into the database and then create a releation between the billboard details using PANEL ID and joining this with the image name i.e Panel ID.

       

      I have been asked to create a cut down version of the database only show LARGE FORMAT billboards and corresponding images - around 1269 records. They can't extra only the images i require, and hence i've had to load all 4,000 images. This now inflates my database and creates all these orphan image records that I don't need - I'm not sure whats the best way to find and remove them?

       

      I don't want to delete 2,714 records manually and would like to run some sort of script that identifies Image Panel ID's that don't have billboard data.

       

      Thanks for your help