Re: Help on Union Query

Mr. May,
The reason you're having trouble is that the problem you've described
does not call for a union query at all.  What you want is a simple GROUP
BY query:

SELECT Node_ID, Word, Count(*) 
FROM NodeIndex
GROUP BY Node_ID, Word

-Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 436-9166  for law firms, small
businesses      fax  436-0137   and non-profit organizations.       pager 338-4078                               San
Francisco