Being fairly new to SQL and everything, it looks like I'm going to need to see if there's an easier way to do something with a join instead of a complicated series of temp tables. Here's the situation.
Found out that some data that we received and processed was incomplete. I have the correct data now in several files. What I need to do is create a list of everything missing from our imports and eventually use that list to process just the missing transactions. >From what I know about Outer Joins (very limited) it doesn't look like it would do what I need. Is there something that would make this quick? We're looking at about 30,000 transactions and the table missing transactions is over a million rows. (David, I've got your book, but it's at home. I promise I'll read everything as soon as I fix this!) Thanks for any help. Ben Fogt aka "The Shark"
