Hi,
I have an Index table with the following structure:
| Node_ID (int) | Word (varchar)|
and attempting to perform a query that returns the distinct Node_ID for
an occurence of [word] in addition to a count of that [word] within the
Node_ID.
Here is the query I have atm:
select distinct on
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___
