Re: seeming simple sql madness

2010-01-14 Thread Jeff Roberts
Thanks for the input Ricardo. for the archive, it turned out that I had four records in the glentrdt file with the same glseq. After I updated my where clause to include "and glentrdt.glaccnt = '60120- ' I didnt get the duplicates any more. 2010/1/13 Ricardo Aráoz : > Jeff Roberts wrote: >> I ha

Re: seeming simple sql madness

2010-01-13 Thread Ricardo Aráoz
Jeff Roberts wrote: > I have been working on a sql statement all afternoon and it is > starting to make me seriously doubt my abilities. I have a table, > glentrdth which has some records I from which need to get records out > for period 13 year 2009. However, this table only contains a glseq > f