Worked perfectly! Thank you! Now if I can only get them imported. Athelene
-----Original Message----- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 2:51 PM To: CF-Talk Subject: RE: SQL Help Needed! This will work in sql server. Don't think access supports compound outer joins... I could be mistaken though... Select * from Docmaster left outer join versions on docmaster.docnum = versions.docnumber and docmaster.version = versions.version Where verersions.docnumber is null -----Original Message----- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:38 PM To: CF-Talk Subject: OT:SQL Help Needed! I just went through a conversion from one product to another. As a part of that process, records were exported via CSV and imported into another MS SQL database. Somewhere along the way, not all of the records were imported. (It was done using the vendor's import utility which was useless in troubleshooting this issue.) The question is this: I want to find all of the records in the original DB that did not make it into the new one. There are only two tables involved. We copied the original table into the new database to make it easier. So now they are both in the same DB. The original table is called DOCMASTER. The new table is called VERSIONS. I need to find all of the records in DOCMASTER that do not exist in VERSIONS. The only way I can tell is from two fields in each. DOCMASTER.DOCNUM should equal VERSIONS.DOCNUMBER And DOCMASTER.VERSION should equal VERSIONS.VERSION How can I write a query to show me every record in DOCMASTER That didn't make it into VERSIONS? I know this should be easy. I apologize in advance. Very sleep deprived at this point. Any help is appreciated. Athelene Gieseman [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
