Greetings R-List, I've got a command line that isn't working. The following command should insert a store number into an exception table if a duplicate work order number exists in a history file.
INSERT INTO exception SELECT DISTINCT storeno FROM invhist WHERE DATESRVC >= .sdate AND DATESRVC <= .edate GROUP BY WORKORD HAVING COUNT(WORKORD) > 1 The table 'exception' has 1 column named 'storeno' The table 'invhist' has 10,000+ rows with a columns: storeno, workord, datesrvc (and others) I'm getting an error message stating "llegal Column specification (2512)" Any pointers would be welcomed! Rob Vincent
