...

>>Second Question:
>>I have created a secondary table that contains the keyword words and
>>number
>>of occurrences. Ultimately such a table can be populated with a simple
>>query:
>>
>>INSERT INTO KEYWORDS_STATS
>>SELECT COUNT(*), KWORD
>>FROM KEYWORDS
>
>Errr.... in the message, you've left off the group by that you
>have in your running query, right?
>
>Regards,
>
>
>Ann

Thanks Ann, you're correct. I forgot a line in the e-mail:

INSERT INTO KEYWORDS_STATS
SELECT COUNT(*), KWORD
FROM KEYWORDS
GROUP BY KWORD

The one I launched a few days ago is correct.

Best Regards

Salim