Right....
I have a table that has a keyword on each row (along with other data that is unimportant for this). A keyword can occur more than once. I have another table with a list of keywords, but each is unique.
I need to return the number of times a given keyword occurs in the first table that also exists in the second table. At the moment there are no keys or indices....
My main problem is not entirely understanding thew group functions I think....
Thanks
Oliver
I have a table that has a keyword on each row (along with other data that is unimportant for this). A keyword can occur more than once. I have another table with a list of keywords, but each is unique.
I need to return the number of times a given keyword occurs in the first table that also exists in the second table. At the moment there are no keys or indices....
My main problem is not entirely understanding thew group functions I think....
Thanks
Oliver