Обсуждение: Help on Union Query

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 (Node_ID) Node_ID from NodeIndex where word='[a word]' union
select count(*) from NodeIndex where Node_ID in (select distinct on (Node_ID)
Node_ID from NodeIndex where word='[a word]') order by count;


Any assistance would be appreciated.
Craig May


Enth Dimension
http://www.enthdimension.com.au

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