CanvasShoes
Registered User.
- Local time
- , 16:04
- Joined
- Sep 25, 2009
- Messages
- 25
Okay, I'm reasonably intelligent when it comes to databases, but this "simple" query is eating my brain. I have two lists of files, each located in a different spot. One contains all names of files that have been uploaded to our database, and the other is the company file storage location. Each list has only one field (should be simple right? you'd think that, but apparently I'm messing something up, even if it only has two parts!!! :banghead
, and that field contains the filenames of documents. The filenames all follow the same naming convention (for the most part unless there's an error and that's part of what I'm looking for).
The database list is the complete list. All that has been done for any of these files will be located there. The storage location is where the copies of the documents get stored, and they don't always get moved from when our vendor sends them to the storage location.
What I want to do is to see what files from the database are not located in the online storage location. But the list that results from doing an unmatched query contains names that ARE in the online storage location (I know this due to my double-check of files).
Am I being totally blonde here? Shouldn't the query return names that are in one list, but not the other, thus providing me with the names that are in the database list, but are not in the online storage backup location?
Help! What am I doing wrong?
, and that field contains the filenames of documents. The filenames all follow the same naming convention (for the most part unless there's an error and that's part of what I'm looking for).The database list is the complete list. All that has been done for any of these files will be located there. The storage location is where the copies of the documents get stored, and they don't always get moved from when our vendor sends them to the storage location.
What I want to do is to see what files from the database are not located in the online storage location. But the list that results from doing an unmatched query contains names that ARE in the online storage location (I know this due to my double-check of files).
Am I being totally blonde here? Shouldn't the query return names that are in one list, but not the other, thus providing me with the names that are in the database list, but are not in the online storage backup location?
Help! What am I doing wrong?
