Marc: Yeah, that "can't be in the destination table" will get you all the time! What I do is to create a temp table that looks like the destination table with just those columns of data that I need to compare. So within the sub-select, reference this copy of the table instead.
Karen > Hi Razzak > > Thanks, I tried the Insert method but get an error about > you can't have the destination table in the where clause > or something like that. Also, I am hitting a snag on > Loading a table from a file. > > No big deal, when I get more time to sit down and work > through this I should be able to get it to work. > > My time is limited because I have to finish dealing with > putting out a fire, literally! > > Thanks again > Marc
